File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 Java Interview Guide this week in the Jobs Discussion 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.

subject: Which OSS database servers support Unicode ?
jQuery in Action, 3rd edition