• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Problem in reading a multilengual XML file into database

 
Ranch Hand
Posts: 65
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
author and deputy
Posts: 3150
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Posts: 3150
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You can also ask this question in our JDBC forum.
 
Ranch Hand
Posts: 245
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 .

 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic