Dear All,

Is there a way to handle special french, spanish character is vi editor (Sun Solaris 8). Foll. is a label in notepad (windows) -
Cliquez ici pour revenir ß la recherche de l'hôtel

this label is stored in a text file, when i tranfer this file to unix using ftp (tried both ansi & bin mode), the label gets converted to

Cliquez ici pour revenir \205 la recherche de l'h\223tel

I use this label to insert into my table. As a result of the special characters my insert clause fails. Is there any settings i need to do so that i can handle these characters.
Thanks in advance.