Re: Java, SQL, Unicode and Databases

From: Jianping Yang (
Date: Thu Jun 22 2000 - 19:11:19 EDT


Oracle doesn't have special requirement for datatype in JDBC driver if you use UTF8 as database
character set. In this case, all the text datatype in JDBC will support Unicode data.


Tex Texin wrote:

> I want to write an application in Java that will store information
> in a database using Unicode. Ideally the application will run
> with any database that supports Unicode. One would presume that the
> JDBC driver would take care of any differences between databases
> so my application could be independent of database.
> (OK, I know it is a naive view.)
> However, I am hearing that databases from different vendors require
> use of different datatypes or limit you to using certain datatypes
> if you want to store Unicode. Changing datatypes would I presume make
> a significant different in my programming of the application...
> So, I want to make a list of the changes I need to make to
> my Java, SQL application in the event I want to
> support each of the major databases (Oracle 8I, MS SQL Server 7,
> etc.) with respect to Unicode data storage.
> (I am sure there are other differences programming to different
> databases, independent of Unicode data, but those issues are
> understood.)
> So, if you can help me by identifying specific changes you would make
> to query or update a major vendor's database with respect to Unicode
> support, I would be very appreciative. If I get a good list, I'll
> post it back here. I am most interested in Oracle and MS SQL Server,
> but will collect info on any database.
> As an example, I am hearing that some databases would require varchar,
> others nchar, for Unicode data.
> tex
> --
> ------------------------------------------------------------------------------------------------
> Tex Texin Director, International Products
> Progress Software Corp. +1-781-280-4271
> 14 Oak Park +1-781-280-4655 (Fax)
> Bedford, MA 01730 USA
> The #1 Embedded Database
> JMS Compliant Messaging- Best Middleware
> Award
> Leading provider in the ASP marketplace
> Progress Globalization Program (New URL)
> ------------------------------------------------------------------------------------------------
> Come to the Panel on Open Source Approaches to Unicode Libraries at
> the Sept. Unicode Conference

This archive was generated by hypermail 2.1.2 : Tue Jul 10 2001 - 17:21:04 EDT