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>
NLS_CHARACTERSET = WE8MSWIN1252
NLS_NCHAR_CHARACTERSET = AL16UTF16 Sample Table:
Create Table myTest ( somevalue NVarchar(50) )
Insert into mytest values (N'$B4pK\>e(B') Insert into mytest values(N'some value')
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