Re: Java, SQL, Unicode and Databases

From: Tex Texin (texin@progress.com)
Date: Fri Jun 23 2000 - 12:50:06 EDT


Joe,

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

Joe_Ross@tivoli.com 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 <kenw@sybase.com> on 06/22/2000 06:42:20 PM
>
> To: "Unicode List" <unicode@unicode.org>
> cc: unicode@unicode.org, kenw@sybase.com, mgm@sybase.com (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        texin@bedford.progress.com

http://www.progress.com The #1 Embedded Database http://www.SonicMQ.com JMS Compliant Messaging- Best Middleware Award http://www.aspconnections.com Leading provider in the ASP marketplace

Progress Globalization Program (New URL) http://www.progress.com/partners/globalization.htm ------------------------------------------------------------------------------------------------ Come to the Panel on Open Source Approaches to Unicode Libraries at the Sept. Unicode Conference http://www.unicode.org/iuc/iuc17



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