Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> How to identify unicode characters in record
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
![]() |
![]() |