[
Lists Home |
Date Index |
Thread Index
]
- From: Michael Rys <mrys@microsoft.com>
- To: "'Dylan Walsh'" <Dylan.Walsh@Kadius.com>, xml-dev@XML.ORG, rpbourret@hotmail.com
- Date: Thu, 15 Jun 2000 10:24:28 -0700
Most databases provide Unicode support (e.g., nchar). Since UTF-8 is an
encoding where the unicode two-byte characters are mapped into a single-byte
character space such that for some characters two or three single-byte
characters are used, you of course can easily store UTF-8 as well in an
single-character string datatype. However, strlen functions are normally
oblivious to the fact that you actually have UTF-8 stored in the later case,
but just from a storage point of view, you should be able to roundtrip
either UTF-8 or Unicode.
I hope this helps
Michael Rys
--
Program Manager, SQL Server XML Technologies
mrys@microsoft.com, rys@acm.org
We store the Web and more...
> -----Original Message-----
> From: Dylan Walsh [mailto:Dylan.Walsh@Kadius.com]
> Sent: Thursday, June 15, 2000 8:12 AM
> To: xml-dev@xml.org; rpbourret@hotmail.com
> Subject: Localisation: Character Encodings & RDBMS,
> Unicode->UTF-8 with
> Ro und Tripping
>
>
> Are there encoding issues with storing XML in a relational database?
> Anyone have any experience with doing this in a database neutral way?
>
> I believe there is Unicode/UTF support in popular databases,
> but I do not
> know much about it.
> Can you convert the various encoding schemes to UTF-8 for storage, and
> convert them back on retrieval? Would such round-tripping
> require you to
> store the name of the original encoding alongside the UTF version?
>
> Any help is appreciated.
>
> **************************************************************
> *************
> This is xml-dev, the mailing list for XML developers.
> To unsubscribe, mailto:majordomo@xml.org&BODY=unsubscribe%20xml-dev
> List archives are available at http://xml.org/archives/xml-dev/
> **************************************************************
> *************
>
***************************************************************************
This is xml-dev, the mailing list for XML developers.
To unsubscribe, mailto:majordomo@xml.org&BODY=unsubscribe%20xml-dev
List archives are available at http://xml.org/archives/xml-dev/
***************************************************************************
|
