Handling Special Charcters

UNIX Solaris
1

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

2

What is dbaccess?

What file did you have to transfer?

3

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