• 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

Issue in character encoding

 
Ranch Hand
Posts: 63
Eclipse IDE Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello friends.......
I am currently working on my project and got stuck with a strange problem..........

I am working on windows machine and using eclipse and tomcat for my application.........

I am reading data from xls file in my application and storing it in database(mysql).....
in my xls sheet when i give non-english characters it got read correctly by my application and stored in the same way
in the database ........

But when i worked on linux machine and using same softwares i.e. eclipse, tomcat and mysql........
my application didn't read xls file having special charaters correctly .......
means it changes it into some other characters and store it in that manner only in database.

And when i debug my appkication in windows while reading it shows workbooksetting encoding cp1252........
but in linux it shows utf-8.......

it troubles me very much........
so please let me get out of this problem.........
 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Whenever you perform character I/O you need to specify which encoding you want to use; if you don't, then the platform default encoding will be used. That's MacRoman on OS X, CP-1252 on Windows, and generally either UTF-8 or ISO-8859-1 on Linux. So you need to think about which encoding you want at which place, and make sure that that gets used everywhere in the code.

Also make sure that the DB is set to use Unicode (or some other encoding that can accommodate all the characters you need to store, but not ASCII).
 
Abhishek Purwar
Ranch Hand
Posts: 63
Eclipse IDE Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Ulf Dittmer wrote:Whenever you perform character I/O you need to specify which encoding you want to use; if you don't, then the platform default encoding will be used. That's MacRoman on OS X, CP-1252 on Windows, and generally either UTF-8 or ISO-8859-1 on Linux. So you need to think about which encoding you want at which place, and make sure that that gets used everywhere in the code.

Also make sure that the DB is set to use Unicode (or some other encoding that can accommodate all the characters you need to store, but not ASCII).



Thanks for your suggestion.
Can you tell me how can i do that so that it can be platform independent???
And i am able to store non-english characters in both platform correctly in the database......
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic