How to handle UTF8 to ASCII text conversion

[moepower]

I have three software systems that transfer data to each other on a daily basis. Two systems are running Oracle8i, the third is not (and does not support UTF8). When I transfer data from UTF8 to ASCII, it garbles any extended characters set. When I try to move the data back, the garble text could not be converted and kill my session.

Is there a command in Oracle where I can use with the Insert statement to detect bad ASCII text and ignore that record? Or is there another way I can handle this. Thanks,

 

[karluk]

The CONVERT function is supposed to handle this type of character set conversion. I would expect that if you use it in both directions for the transfer to and from UTF8 to ASCII that your only problem would be loss of extended character data.