RE: AL32UTF8 Vs UTF8

[Carl W. Brown]

Jay,

 

Oracle's UTF-8 is not really a valid encoding.  It encodes surrogates as if they were characters.  The kept the old Unicode 2.x code that only supports BMP to provide sort key compatibility for clients who never upgraded to Unicode 3.0 support and are using 16 bit character encoding improperly.  UTF8 sorts in the same way as the old 16 bit Unicode before surrogates.  Do not use UTF8  because it is really not Unicode conformant with any Unicode standard.  Instead use AL32UTF8.

 

Carl

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jay Chandru
Sent: Sunday, August 10, 2003 8:58 AM
To: [EMAIL PROTECTED]
Subject: AL32UTF8 Vs UTF8

Greetings,

 

We are using Oracle9i with application tier as 11i.

 

I wanted to know the differences between AL32UTF8 and UTF8. My database (oracle) will be in AL32UTF8 format. Will the applications that require multibyte characters work as they are functionin in UTF8 format.

 

Would be great if anybody can gimme a comparision on AL32UTF8 and UTF8

 

Also pls list requirement of any 3rd party softwares for code page conversions in case of AL32UTF8

 

Thanks in advance,

-Jay

---

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software