Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to use NCHAR and NCLOB?
I'm trying to store Unicode characters into a NCHAR column.
I need help too.
I've defined a simple table such as XYZ:
ACCOUNT NCHAR(9) Outside of SQL*PLUS,I:
EXPORT NLS_LANG=AMERICAN.UTF8 When I try from SQL*PLUS:
INSERT INTO XYZ VALUES('123456789'); I get ORA-12784: character set mismatch.
I suspect that Oracle requires me to pass it a UTF8-format string. But I went to Basis Technology's web page and downloaded their uniconv.exe utility that converts any text from one code to another. Here I translated from ASCII to UTF8 and the before and after strings look IDENTICAL. And Oracle explicitly states that it supports UTF8 ONLY for Unicode and noty UCS-2!
Paul
In article <3678CAEE.6DDFD198_at_polyu.edu.hk>,
Antony MA <bsykma_at_polyu.edu.hk> wrote:
> Hi ,
> I spent hours on the Oracle documentation and still need help.
> I am tring to store Chinese (GB encoded text). How should I do?
>
> As far as I know, there is database character set and national
> character set.
>
> Can a database storage 2 different character sets. What is the use of
> national
> character set and how to define its parameters?
>
> Thanks
>
> Antony MA
>
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Dec 29 1998 - 13:34:44 CST