National language support
433409Oct 25 2011 — edited Oct 25 2011Am working on National language support , and to understand i did small example below
Am using Oracle 10g,windows.
My client(desktop) NSL_LANG is set to AMERICAN_AMERICA.AL32UTF8 and
database character set is set to AL32UTF8
CREATE TABLE char_table (xDecimal NUMBER, xBinary NUMBER, xGraphic CHAR(4));
SQL> INSERT INTO char_table VALUES (117 ,01110101 ,'u');
1 row created.
SQL> INSERT INTO char_table VALUES (214 ,11010110 ,'Ö');
ERROR:
ORA-01756: quoted string not properly terminated
Please help me.