Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to identify unicode characters in record
Ana C. Dent schreef:
> If I am having a good day, I can barely spell unicode.
> We are in the process of upgrading our application to support unicode
> characters.
> CREATE TABLE LOOKUP
> (ID NUMBER,
> DESCRIPTION VARCHAR2(320));
> This table exists in a 10GR2 database that supports UTF-8 character set.
>
>
You already have two answers, but I would like to point
to a possible point of failure:
CREATE TABLE LOOKUP
(ID NUMBER,
DESCRIPTION VARCHAR2(320));
should ideally read:
CREATE TABLE LOOKUP
(ID NUMBER,
DESCRIPTION VARCHAR2(320 char));
or your database semantics must be character
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Thu Sep 07 2006 - 14:22:17 CDT
![]() |
![]() |