Hello together,
I have a little problem with inserting / updateing data from PHP to Oracle. My Oracle charset setup is:
NLS_CHARACTERSET=WE8MSWIN1252 and NLS_NCHAR_CHARACTERSET=AL16UTF16
Now I want to put in some cyrillic signs. My SQL-statement looks like:
update table set
field_1 = utl_raw.cast_to_nvarchar2(utl_raw.convert('пуищ','AMERICAN_AMERICA.AL16UTF16','AMERICAN_AMERICA.AL32UTF8')),
field_2 = utl_raw.cast_to_nvarchar2(utl_raw.convert('','AMERICAN_AMERICA.AL16UTF16','AMERICAN_AMERICA.AL32UTF8'))
where rtrim(field_3,' ') = '1014006981' and langcode = 'RU';
My error message is:
SQL-Fehler: ORA-01465: invalid hex number
01465. 00000 - "invalid hex number"
*Cause:
*Action:
I hope someone of has the answer.
Thank you very much
Stephan