Dear All,

I have created a UTF-8 database to store multi-lingual charcters. Below is the query from which i insert from Winsql (front-end third party database browser tool), the data gets inserted properly.

insert into a (no, lbl)
values (1, "Cliquez ici pour revenir Ã_ la recherche de l'hôtel");

Now when i try to insert the same query through dbaccess it gives me an error " 202: An illegal character has been found in the statement."
When i view the query in vi editor -

insert into a (no, lbl)
values (2, "Cliquez ici pour revenir \205 la recherche de l'h\223tel");
# ^
# 202: An illegal character has been found in the statement.
#

I tried to ftp the file in both ASCII & binary mode, but no luck.
Is there a way how i can handle these special characters. I am using sun solaris 8 and Informix Database.

Regards,

lloyd

What is dbaccess?

What file did you have to transfer?

Hi,

Dbaccess is an informix tool to browse the database on unix.
The file contains all the insert statements. When i transfter the file the special characters gets converted and i get an error.
You may come to know from my earlier posts. I need to handle those special characters.

Regards,

lloyd