Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Unicode support in ORACLE 8i???

Re: Unicode support in ORACLE 8i???

From: Kirk Cameron <cameron_at_bicnet.net>
Date: Mon, 29 Mar 1999 14:45:20 -0500
Message-ID: <36FFD850.2FF30602@bicnet.net>


It is not so much a datatype as the character set used when the database is created. In 8.i you can create a database with the UTF8 characterset. This is a varying width characterset implementation of unicode. There is also a fixed width implementation called UCS2 which oracle does not support. Once the database is created all character fields are stored in UTF8, no special datatype is needed. Remember that you must create the database as UTF8, you can't change the characterset later. (I have seen some posts that describe how to alter the characterset but it is not supported by Oracle and I am not brave enough to try.)

Kirk

david wrote:

> Does anyone know if Oracle 8i has a datatype that supports unicode
> characters???????????
>
> thanks,
>
> DavidVonMatt
> david_at_prsn.com
Received on Mon Mar 29 1999 - 13:45:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US