Handling Special Characters
This is a
multipart mime message
--Next_1099376231---0-202.54.124.151-2553
Content-type: text/html;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
<P>=0ADear All,<BR>=0A<BR>=0AI have created a UTF-8 database to store multi=
-lingual charcters. Below is the query from which i insert from Winsq=
l (front-end third party database browser tool), the data gets inserted pro=
perly.<BR>=0A<BR>=0Ainsert into a (no, lbl) <BR>=0Avalues (1, "Cliquez=
ici pour revenir =C3 la recherche de l'h=C3=B4tel");<BR>=0A<BR>=
=0ANow when i try to insert the same query through dbaccess it gives me an =
error " 202: An illegal character has been found in the statemen=
t."<BR>=0AWhen i view the query in vi editor -<BR>=0A<BR>=0Ainsert int=
o a (no, lbl)<BR>=0Avalues (2, "Cliquez ici pour revenir \\\\205 la reche=
rche de l'h\\\\223tel");<BR>=0A# ^<BR>=
=0A# 202: An illegal character has been found in the statement.<BR>=
=0A#<BR>=0A<BR>=0AI tried to ftp the file in both ASCII & binary mode, =
but no luck.<BR>=0AIs there a way how i can handle these special characters=
. I am using sun solaris 8.<BR>=0A<BR>=0ARegards,<BR>=0A<BR>=0Alloyd<=
BR>=0A =C2=A0<BR>=0A=0A</P>=0A<br><br>=0A<A target=3D"_blank" HREF=3D"http:=
//clients.rediff.com/signature/track_sig.asp"><IMG SRC=3D"http://ads.rediff=
.com/RealMedia/ads/adstream_nx.cgi/www.rediffmail.com/inbox.htm@Bottom" BOR=
DER=3D0 VSPACE=3D0 HSPACE=3D0></a>=0A
--Next_1099376231---0-202.54.124.151-2553
Content-type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Dear All,=0A=0AI have created a UTF-8 database to store multi-lingual charc=
ters. Below is the query from which i insert from Winsql (front-end third =
party database browser tool), the data gets inserted properly.=0A=0Ainsert =
into a (no, lbl) =0Avalues (1, "Cliquez ici pour revenir =C3=A0 la recherch=
e de l'h=C3=B4tel");=0A=0ANow when i try to insert the same query through d=
baccess it gives me an error " 202: An illegal character has been found in=
the statement."=0AWhen i view the query in vi editor -=0A=0Ainsert into a =
(no, lbl)=0Avalues (2, "Cliquez ici pour revenir \\\\205 la recherche de l'h\\\\2=
23tel");=0A# ^=0A# 202: An illegal character has been found in th=
e statement.=0A#=0A=0AI tried to ftp the file in both ASCII & binary mode, =
but no luck.=0AIs there a way how i can handle these special characters. I=
am using sun solaris 8.=0A=0ARegards,=0A=0Alloyd=0A =C2=A0=0A
--Next_1099376231---0-202.54.124.151-2553--