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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
106 views