Re: Java, SQL, Unicode and Databases

Date: Fri Jun 23 2000 - 17:13:43 EDT

Yes, version 7. It requires us to use a different data type (nchar) if we want
to store multilingual text as UTF-16. We want our applications to be database
vendor independent so that customers can use any database under the covers. If
all databases supported UTF-8 as an encoding for char, we could support
multilingual data in the same way for all vendors. As it is, we have to use a
different schema for MS SQL server than we do for the others.

"Tex Texin" <> on 06/23/2000 11:50:06 AM

To: Joe Ross/Tivoli Systems@Tivoli Systems
cc: Unicode List <>, Hossein Kushki@IBMCA, Vladimir Dvorkin
      <>, Steven Watt <>
Subject: Re: Java, SQL, Unicode and Databases


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
> trouble, because it doesn't support UTF-8 as a database encoding for char,
> Joe
> Kenneth Whistler <> on 06/22/2000 06:42:20 PM
> To: "Unicode List" <>
> cc:,, (bcc: Joe
> Systems)
> Subject: Re: Java, SQL, Unicode and Databases
> Jianping responded:
> >
> > Tex,
> >
> > Oracle doesn't have special requirement for datatype in JDBC driver if you
> 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