Hi Its two days which im in fight with a severe problem in XML/JAVA/JDBC arena I have an XML file its a glossary which has some thousands of difinition. each difinition is a word with two parts , one of this parts is hebrew and the other is english . (hebrew is explanation of english term).
The XML file is unicode , i tried to read it with XMLdocument and store it into database , but a big problem araise here
All hebrew character replaced with ? in database ? does any one know why ? I tried almost all OS database like Mysql (i used useunicode parameter for it) postgreSQL , Firebird and cloudscape But still what i get is not more that ??? . Shoud i do some convertion before inserting them into database ?
In brief : My problem is reading an XML file with multilanguage content and inserting its data into database , in a manner that my hebrew does not convert to ???
I am loading file having multilungual characters into our Oracle DB. For Oracle we had to upgrade out character set to UTF8.
NLS parameter setting is what needs to be set to have right value.
Let me know if that helps.
Joined: Mar 30, 2005
Hi Thank you all for your answers I have not Access to Oracle DB I can just use Opensource Databases Like Mysql , firebird , PostgreSQL , derby ,Ingress ,even Daffodil I checked with all of this databases and nothing happed. It is really going to kill me .
I checked for client charset (a friend at JDBC forum mentioned this) I think it is true because i can read and see correct chars when i open the xml file in ECLIPSE / Wordpad .