Re: UTF-16 or UTF-32 on Oracle 8

From: Jianping Yang (
Date: Fri Apr 14 2000 - 17:43:27 EDT

Oracle8 does not support UTF-32 encoding form as database character set
in its access API. If you want to make simplicity for your case, you may

use BLOB to store UTF-32 in database without any character set

If you have any more question, please send to me directly.


attilla ong wrote:

> Hi Folks,
> If this topic has already been beaten to death,
> please direct me to the Oracle I18N expert that I know
> is on the mailing list :-)
> We have initially plan to save our data as UTF-32.
> We have opted for the simplicity over size of
> database. We just installed Oracle but realize that it
> supports only UTF-8 naturally (at least according to
> its documentation).
> The question is whether Oracle8 supports UTF-32
> natively without us having to coerce a character into
> a 4-byte datatype. If not, what are the consequences
> of insisting of storing an array of UTF-32 characters
> as an array of 4-byte-datatype (or whatever it's
> called).
> excerpt from Oracle 8's documentation:
> "The Unicode character repertoire can be represented
> in a number of different encoding formats. UCS-2 is a
> two-byte fixed-width format, UTF-8 is a multi-byte
> format with variable width. Oracle8 supports the
> UTF-8 format only. UTF-8 is an ASCII-compatible
> encoding scheme. The Oracle character set name for
> Unicode 2.0 is "UTF8". Unicode 1.1 has been supported
> with the Oracle character set name of "AL24UTFFSS"
> since Oracle7"
> Thank you.
> __________________________________________________
> Do You Yahoo!?
> Send online invitations with Yahoo! Invites.

This archive was generated by hypermail 2.1.2 : Tue Jul 10 2001 - 17:21:02 EDT