aspose file tools*
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 Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Which OSS database servers support Unicode ?" Watch "Which OSS database servers support Unicode ?" New topic
Author

Which OSS database servers support Unicode ?

Ramina Nibilian
Ranch Hand

Joined: Mar 30, 2005
Posts: 65
Hi
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
Author
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 :
www.firebird.org an opensource version of Interbase 6 from borland.
www.postgresql.org postgreSQL
http://daffodildb.com/ 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
Greenhorn

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.

Peace,
Phillip
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Which OSS database servers support Unicode ?