It's not a secret anymore!
The moose likes JDBC and Relational Databases 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 REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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.

It is sorta covered in the JavaRanch Style Guide.
subject: Which OSS database servers support Unicode ?
It's not a secret anymore!