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
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
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.