Re: Java, SQL, Unicode and Databases

From: Tex Texin (
Date: Fri Jun 23 2000 - 12:50:06 EDT


Can you expand on this a bit more? Privately if you prefer.
Do you mean version 7 of MS SQL Server?

I assume if it doesn't have UTF-8, it uses UTF-16. How does this
being the storage encoding, become problematic?
tex wrote:
> I think that this is also true for DB2 using UTF-8 as the database encoding.
> From an application perspective, MS SQL Server is the one that gives us the most
> trouble, because it doesn't support UTF-8 as a database encoding for char, etc.
> Joe
> Kenneth Whistler <> on 06/22/2000 06:42:20 PM
> To: "Unicode List" <>
> cc:,, (bcc: Joe Ross/Tivoli
> Systems)
> Subject: Re: Java, SQL, Unicode and Databases
> Jianping responded:
> >
> > Tex,
> >
> > 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.
> >
> The same thing is, of course, true for Sybase databases using UTF-8
> at the database character set, accessing them through a JDBC driver.
> But I think Tex's question is aimed at the much murkier area
> of what the various database vendors' strategies are for dealing
> with UTF-16 Unicode as a datatype. In that area, the answers for
> what a cross-platform application vendor needs to do and for how
> JDBC drivers might abstract differences in database implementations
> are still unclear.
> --Ken

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