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 -> How to identify unicode characters in record

How to identify unicode characters in record

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Thu, 07 Sep 2006 02:27:02 GMT
Message-ID: <Xns9836C5DB85016banspamoperamailcom@70.168.83.30>


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.

How do I query the databse to return all the IDs where DESCRIPTION contains 1 or more unicode (non-ASCII) characters?

I am more than willing to RTFM, if you point me at which FM has the answer.

Free clues would be much appreciated.

TIA! Received on Wed Sep 06 2006 - 21:27:02 CDT

Original text of this message

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