convert UTF8 to WE8ISO8859P1 or WE8ISO8859P15
Hi!
If got the following situation:
I've got a database with the character set WE8ISO8859P1.
I've got a second database with UTF8.
I think all databases are 10.2.xx
There is a pl/sql interface on the WE8ISO8859P1 Database which reads data from the UTF8 database via database link.
But after inserting UTF8-data into the WE8ISO8859P1 database, the are not converted correctly automaticaly.
How can i convert UTF8-data within my WE8ISO8859P1 database to WE8ISO8859P1-data?
Is there a standard function within the WE8ISO8859P1 database?
e.g. Select standard_convert_func(my_col, 'UTF8', 'WE8ISO8859P1') from myTable@db_link
Or is the better way to convert this utf8-data to WE8ISO8859P1 within the UTF-8 database?
insert into my_interface_tabele(my_col) select standard_convert_func(my_col, 'UTF8', 'WE8ISO8859P1') from my_utf8_base_tabel;
Thank you for your help!
Best regards,
Thomas