Inserting/Updating Unicode Data

From: rob <rob_panosh_at_asdsoftware.com>
Date: Wed, 10 Sep 2008 10:46:19 -0700 (PDT)
Message-ID: <a1305873-6e03-41cd-bf45-b0b54f900608@k37g2000hsf.googlegroups.com>


Hello,

I am trying to store Unicode characters (i.e. - Chinese, Polish, French, English, ... )
in my database tables.

Current NLS settings:



NLS_CHARACTERSET = WE8MSWIN1252
NLS_NCHAR_CHARACTERSET = AL16UTF16 Sample Table:

Create Table myTest ( somevalue NVarchar(50) )

Sample Insert:



Insert into mytest values (N'$B4pK\>e(B') Insert into mytest values(N'some value')

When I execute the above sql select statement the chinese characters are NOT inserted into the database. I get upside down question marks instead.

Any help would be greatly appreciated.

Thanks,
Rob Panosh
Advanced Software Designs Received on Wed Sep 10 2008 - 12:46:19 CDT

Original text of this message