This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets 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
 
 
subject: Which OSS database servers support Unicode ?
 
Similar Threads
Problem in reading a multilengual XML file into database
Reading swedish characters thro DataInputStream
Read Unicode chars and insert into Oracle DB
Insert arabic data in database through jsp file
How to handle special characters in web application