[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

RE: Localisation: Character Encodings & RDBMS, Unicode->UTF-8 with Ro un

  • From: Michael Rys <mrys@m...>
  • To: "'Dylan Walsh'" <Dylan.Walsh@K...>, xml-dev@X..., rpbourret@h...
  • Date: Thu, 15 Jun 2000 10:24:28 -0700

mailto unicode
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@m..., rys@a...
We store the Web and more...

> -----Original Message-----
> From: Dylan Walsh [mailto:Dylan.Walsh@K...]
> Sent: Thursday, June 15, 2000 8:12 AM
> To: xml-dev@x...; rpbourret@h...
> 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@x...&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@x...&BODY=unsubscribe%20xml-dev
List archives are available at http://xml.org/archives/xml-dev/
***************************************************************************

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
 

Stylus Studio has published XML-DEV in RSS and ATOM formats, enabling users to easily subcribe to the list from their preferred news reader application.


Stylus Studio Sponsored Links are added links designed to provide related and additional information to the visitors of this website. they were not included by the author in the initial post. To view the content without the Sponsor Links please click here.

Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.