I am using Oracle 10.2.0.2 on Solaris SPARC
We had issues while inserting special characters into a table.
The character set of the database is AL32UTF8.
When I insert values from Windows using Oracle 10g client I am able to insert special characters but when I do the same from Linux I was not able to since the data became corrupt.
NLS_LANG was not set in Linux and that was the reason. I did set the
NLS_LANG to American_America.AL32UTF8 and tried
SQL> insert into sample values('Santamarķa');
ERROR:
ORA-01756: quoted string not properly terminated
Santamarķa
I did set NLS_LANG to American_America.WE8ISO8859P1 in Windows and tried inserting the data
SQL> insert into sample values('Santamarķa');
1 row created.
SQL> commit;
Commit complete.
Did the same in Linux and tried
SQL> insert into sample values('Santamarķa');
1 row created.
SQL> commit;
Commit complete.
Now tried querying the data from Windows
SQL> select * from sample;
NAME
-----------------------------------------------------------------------------
Santamarķa
SantamarŻa
and then in Linux
SQL> select * from sample;
NAME
--------------------------------------------------------------------------------
Santamar”a
Santamarķa
The data I inserted in Linux appears corrupted in Windows and the vice versa.
What should the NLS_LANG variable be set to ?
] 
Blog
Search
Help
Members
Register
Login
Home
