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" <[EMAIL PROTECTED]> on 06/23/2000 11:50:06 AM
To: Joe Ross/Tivoli Systems@Tivoli Systems
cc: Unicode List <[EMAIL PROTECTED]>, Hossein Kushki@IBMCA, Vladimir Dvorkin
<[EMAIL PROTECTED]>, Steven Watt <[EMAIL PROTECTED]>
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
[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> on 06/22/2000 06:42:20 PM
>
> To: "Unicode List" <[EMAIL PROTECTED]>
> cc: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] (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 [EMAIL PROTECTED]
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
