Hi all,
I have a problem in canverting some character column in my database.
I have exported one table from one database Windows Oracle 10g which contains one column type of varchar2 but the content is an ENCRYPTED BINARY (like for example "bp0 EBo"), in this source database we are using function called RAWTOHEX to get the format of this colum in hexadecimal and it is working properly.
The problem is we were importing this tables in a new Oracle database 11gR1 (Linux Debian 6) and using the same Query but in this new database we don't get decimal formatlike below:
select rowtohex(msisdn) from su_data;
24055122BF10FFFF
Note that during importation we got a duplicate value error in indexe creation which may be caused by incoherence of CHARACTER SET of the two database.
import server uses WE8MSWIN1252 character set (possible charset conversion)
export client uses WE8ISO8859P1 character set (possible charset conversion)
The Source database character set is WE8ISO8859P1 and the destination is WE8MSWIN1252.
Could you please help in how to solve this problem, can set change character set during importation only or i have to change database character set.
Can i do the conversion from Oracel Query like using conversion function, if yes which function is the best ?
Ragards,
Raluce.