Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

National language support

433409Oct 25 2011 — edited Oct 25 2011
Am 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.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 22 2011
Added on Oct 25 2011
6 comments
130 views