This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Which OSS database servers support Unicode ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Which OSS database servers support Unicode ?" Watch "Which OSS database servers support Unicode ?" New topic

Which OSS database servers support Unicode ?

Ramina Nibilian
Ranch Hand

Joined: Mar 30, 2005
Posts: 65
CAn some one pleas tell me which opensource Database server support unicode correctly ?
I tried Mysql and when i failed with all changes in connection url (useUnicode=true ...) i deside to use Ms sql server.
So im looking for OSS databse which support Unicode.
thank you
Masoud Kalali
Ranch Hand

Joined: Jul 08, 2004
Posts: 531

Hi Ramina
Mysql Support unicode at least 4+ version supports
There are several unicode support RDBMS in OSS or commercial
for example : an opensource version of Interbase 6 from borland. postgreSQL there is an opensource of it.
Derby from apache Foundation support unicode too.

All major Commerical RDBMS support Unicode .
Hope it helps

Masoud Kalali
Software Engineer - My Weblog - GlassFish Security
Phillip Koebbe

Joined: Jun 22, 2005
Posts: 27
I'm using MySQL 4.1.11. As far as I know, you don't have to specify anything in the connection properties. It's the character set that you define for storing strings. I think the default for MySQL is latin1, but you can either set a server wide default at startup (in my.conf/my.ini), per database, per table, or per column. I have noticed some irregularity between specifying the default character set in the configuration and whether or not a table gets created with that character set, so I always include it in the CREATE DATABASE and CREATE TABLE statements, just to make sure. So when I'm creating a table, I'll do:

Look at chapters 10 and 5 in the MySQL Reference Manual for more information on character sets and collation.

I agree. Here's the link:
subject: Which OSS database servers support Unicode ?
Similar Threads
Problem in reading a multilengual XML file into database
Reading swedish characters thro DataInputStream
Read Unicode chars and insert into Oracle DB
Insert arabic data in database through jsp file
How to handle special characters in web application