Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Support localization in CLOB filed in DB through java

 
shardul chand
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am facing problems with setting Latin-1 Supplement characters and Double byte characters in CLOB field in DB through Java code.

The part of the code I am using to set data in the DB with encoding is:



Here the callablestatement executes the following:
begin update test_clob tc set tc.id = " + "empty_clob() where tc.key1 = 1 returning tc.id into ? ; end;

Later the callablestatement and the placeholder position is passed to the upper method and they update the DB.


Code for retrieving the value :





Here the select statement is fired and the returned CLOB filed is passed to the above function and it returns a String.

This is not working when I am writing "ä" into the CLOB filed with encoding "Cp1252".

Another problem is that the data in the CLOB is an xml and the name of the node are in English and the value of the node is to be localized (<AltText>Test ä</AltText> or <AltText>せんせい</AltText>).

Please can anyone help me with why this is not working or if there is any other way to do it.

Thanks.


 
Jan Cumps
Bartender
Posts: 2586
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
shardul,

Welcome to JavaRanch.
Please take some time learn how to properly format your code.
 
shardul chand
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the link Jan.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic