No subject
Fri May 2 19:13:14 EDT 2003
The problem is that when i do the insert, the text in the database is
being stored with the wrong codepage and i actually get junk.
=20
I've search through the archives but couldn't come up with something.
I have:
=20
cat /etc/sysconfig/i18n
LANG=3D"el_GR"
SUPPORTED=3D"en_US:en:el_GR:el"
SYSFONT=3D"gr.f16"
SYSFONTACM=3D"iso07"
I also changed nvarchar to text but still the same.
I can select data from the server ok without any problems.
=20
Can you guys help me?
What info do you need from that can help you.
I have freetds-0.60-1 rpm installed.
=20
Regards,
Spyros
------_=_NextPart_001_01C2B657.F435423A
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<TITLE>Message</TITLE>
<META content=3D"MSHTML 6.00.2800.1126" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D869341514-07012003>I have =
the following=20
problem:</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D869341514-07012003></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D869341514-07012003>From a =
linux box i=20
try to do a insert into a MSSQL Server 2000 table.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D869341514-07012003>The =
problem is that=20
when i do the insert, the text in the database is being stored with the =
wrong=20
codepage and i actually get junk.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D869341514-07012003></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D869341514-07012003>I've =
search through=20
the archives but couldn't come up with something.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D869341514-07012003>I=20
have:</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D869341514-07012003></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D869341514-07012003>cat=20
/etc/sysconfig/i18n<BR>LANG=3D"el_GR"<BR>SUPPORTED=3D"en_US:en:el_GR:el"<=
BR>SYSFONT=3D"gr.f16"<BR>SYSFONTACM=3D"iso07"<BR></SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D869341514-07012003>I also =
changed=20
nvarchar to text but still the same.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D869341514-07012003>I can =
select data=20
from the server ok without any problems.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D869341514-07012003></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D869341514-07012003>Can =
you guys help=20
me?</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D869341514-07012003>What =
info do you=20
need from that can help you.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D869341514-07012003>I have =
freetds-0.60-1 rpm installed.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D869341514-07012003></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D869341514-07012003>Regards,</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D869341514-07012003>Spyros</DIV></SPAN></FONT></BODY></HTML>
------_=_NextPart_001_01C2B657.F435423A--
More information about the FreeTDS
mailing list