Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Which OSS database servers support Unicode ?

 
Ramina Nibilian
Ranch Hand
Posts: 65
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 531
Java Mac OS X Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic