Hi,
I want to insert some FINNISH language data into one of my tables. After insertion the data is displaying as some junk values. I am trying to reset my NLS_LANG parameter as to reflect FINLAND_FINNISH.<Char set>. But i am unable to perform this chagne.
My current database is showing below output
SQL> SELECT USERENV('language') FROM DUAL;
USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.WE8ISO8859P15
I wnat to chagne the above to reflect Finnish data. How can i do it? i tried below statement but failed
SQL> Alter session set NLS_LANG="FINNISH_FINLAND.WE8ISO8859P15";
Alter session set NLS_LANG="FINNISH_FINLAND.WE8ISO8859P15"
*
ERROR at line 1:
ORA-00922: missing or invalid option
Could someone please shed some light on this issue.
Database version : 10.2.0.5
OS : HP UX
The insert query what i am firing is :
insert into test values ('İçerenköy Mah. Askent sok., Ataşehir, P.O Box 321, Wärtsilä Finland Oy, 65101 Vaasa, FINLAND','İçerenköy Mah. Askent sok., Ataşehir, P.O Box 321, Wärtsilä Finland Oy, 65101 Vaasa, FINLAND');
And the output i am getting is
SQL> select * from test;
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
.gerenkvy Mah. Askent sok., Ata.ehir, P.O Box 321, Wdrtsild Finland Oy, 65101 Va
asa, FINLAND
.gerenkvy Mah. Askent sok., Ata.ehir, P.O Box 321, Wdrtsild Finland Oy, 65101 Va
asa, FINLAND
Thank you