Which OSS database servers support Unicode ?

[Ramina Nibilian]

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]

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

[Phillip Koebbe]

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:

CREATE TABLE MyTable
(
  Col1 VARCHAR(15) NOT NULL,
  Col2 VARCHAR(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

Peace,
Phillip