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.
Joe
"Tex Texin" <texin@progress.com> on 06/23/2000 11:50:06 AM
To: Joe Ross/Tivoli Systems@Tivoli Systems
cc: Unicode List <unicode@unicode.org>, Hossein Kushki@IBMCA, Vladimir Dvorkin
<vdvorkin@progress.com>, Steven Watt <swatt@progress.com>
Subject: Re: Java, SQL, Unicode and Databases
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