aspose file tools*
The moose likes XML and Related Technologies and the fly likes Problem in reading a multilengual XML file into database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of JavaScript Promises Essentials this week in the JavaScript forum!
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "Problem in reading a multilengual XML file into database" Watch "Problem in reading a multilengual XML file into database" New topic
Author

Problem in reading a multilengual XML file into database

Ramina Nibilian
Ranch Hand

Joined: Mar 30, 2005
Posts: 65
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

Joined: Jul 13, 2001
Posts: 3150
IMHO the database field or column should support unicode; For example SQL Server 2000 has the datatype varchar-unicode


Spritle Software Blogs
Balaji Loganathan
author and deputy
Bartender

Joined: Jul 13, 2001
Posts: 3150
You can also ask this question in our JDBC forum.
Gemini Moses
Ranch Hand

Joined: Jan 04, 2001
Posts: 245
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

Joined: Mar 30, 2005
Posts: 65
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 .

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem in reading a multilengual XML file into database