字符集 AL32UTF8 和 UTF8.docVIP

字符集 AL32UTF8 和 UTF8 标签：字符集 AL32UTF8 和 UTF8 The difference between UTF8 and AL32UTF8 are: ITPUB个人空间E(K |?A] a0S4}_)I1{6X+pd#X0UTF8 stores Unicode characters with code points U+FFFF as two surrogate characters, three bytes each S2|*ea/QDf%O0ITPUB个人空间9_4]mXU.y%BAL32UTF8 stores Unicode characters with code points U+FFFF as one four-byte character ITPUB个人空间3n:i,ue4m2Ehw$b@
A4x BO}!nzHd7wI0 UTF8 will not be updated anymore when new Unicode versions are released, only AL32UTF8 and AL16UTF16 will. 8O[
j(AW\DJ`7K0ITPUB个人空间vl%]j0l:sMDue to compatibility problems with pre-9i versions use UTF8 if you have Oracle8i clients connecting to the database. Use AL32UTF8 in pure Oracle9i environment. ITPUB个人空间/{` E)m%e(Q\-vITPUB个人空间|~w_Kf,kUTF-8 encoding is variable-width. In UTF-8, each character can be represented by either one, two, or three bytes. E[-r]M3z0I*g1ra1LuI b5H0UTF8 is a varying width 1-3 bytes per character Unicode encoding. It is supported for both database and national character sets. It is a binary superset of US7ASCII. UTF8 corresponds to Unicode CESU-8 encoding. ITPUB个人空间Cx J*_gt{veITPUB个人空间6q6y
B(u4zAL32UTF8 is a varying width 1-4 bytes per character. It is supported for CHAR, VARCHAR2, LONG and CLOB only (database character set). It is a binary superset of UTF8 (in 9.2 only) and US7ASCII. AL32UTF8 corresponds to Unicode UTF-8 encoding. This is what Metalink says. In Note: 237593.1 ITPUB个人空间 Q(Gv}8DDiC IITPUB个人空间oM{~ l } WThere is a possible problem for 817 and lower versions: Problems connecting to AL32UTF8 databases from older versions 8i and lower.ITPUB个人空间7kr3Q(R4PiMITPUB个人空间ZSo\X+}-P1OThe default UTF8 characterset for 9i/10G is AL32UTF8, however this characterset is NOT recognised by any pre-9i clients/server systems.s8q%Q:_~ q p0ITPUB个人空间`R9LgY m]Oracle recommends that you use UTF8 instead of AL32UTF8 as database characterset if you have 8i (or older) servers and clients co