[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
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! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|