Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem in reading a multilengual XML file into database

 
Ramina Nibilian
Ranch Hand
Posts: 65
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ???


pleas help
 
Balaji Loganathan
author and deputy
Bartender
Posts: 3150
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
IMHO the database field or column should support unicode; For example SQL Server 2000 has the datatype varchar-unicode
 
Balaji Loganathan
author and deputy
Bartender
Posts: 3150
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can also ask this question in our JDBC forum.
 
Gemini Moses
Ranch Hand
Posts: 245
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

Thanks
Gemini
 
Ramina Nibilian
Ranch Hand
Posts: 65
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 .

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic