Unicode baltic charachters in plsql
505408Nov 20 2009 — edited Nov 20 2009Hello, im creating a number spell function based on [Tom Kyte's article |http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1407603857650]
I have unicode letters in my plsql function as : , 'fifty' , 'penkiasdešimt'
when i run the code it doesnt return the š character in the correct format.
Database settings:
SQL> select * from nls_database_parameters where parameter like '%CHARACTERSET';
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_CHARACTERSET
AL32UTF8
NLS_NCHAR_CHARACTERSET
AL16UTF16
example:
select spell_number_lt(2321) from dual;
du-t×kstantŃai tri-Õimtai dvideÕimt-vienas
how to create the function without effecting the baltic letters.