Home » Open Source » Programming Interfaces » PHP insert or update nvarchar2 (PHP 5.2.16, Oracle 9i, OCI8 from Instant Client 10.2.x)
PHP insert or update nvarchar2 [message #542604] Wed, 08 February 2012 03:30 Go to previous message
stephan.wild
Messages: 4
Registered: February 2012
Location: Regensburg - Bavaria - Ge...
Junior Member
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
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Software Engineer
Next Topic: IST sysdate default is not working with Entity Framwork
Goto Forum:
  


Current Time: Thu Mar 28 04:05:47 CDT 2024