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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to identify unicode characters in record

Re: How to identify unicode characters in record

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 07 Sep 2006 21:22:17 +0200
Message-ID: <edpr7d$o0g$1@news3.zwoll1.ov.home.nl>


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

Original text of this message

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