Hello. I need to insert some data from XML into Oracle. I extract tables from XML using xmlmap. Both XML and XMLMAP have 'UTF-8' encoding. When I select some string columns from created tables I get normal cyrillic symbols, such as 'тестовая строка'. But when I insert them into Oracle tables, these letters turn into '���������� ������'. When I try to select these Oracle tables in proc sql statement, I get '???????? ??????'. Do you have any suggestions, what's the problem. proc sql;
select * from XMLLIB.Table_Name; /*Checking string data, getting 'тестовая строка'*/
insert into ORALIB.Table_Name
select * from XMLLIB.Talbe_Name; /*Insert data into Oracle Talbe, returns '�������� ������'*/
select * from ORACLE.Table_Name; /*returns '???????? ??????'*/
quit; Once again: both &CUR_XML and &CUR_MAP have 'UTF-8' encoding. Thanks in advance.
... View more