FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

From: Ioakim Spyros [mailto:sioakim AT ace-hellas.gr]
Sent: January 7, 2003 9:21 AM
 
> From a linux box i try to do a insert into a MSSQL Server 2000 table.
> 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.
 
Spyros, 

Make you have have:

1. configure --with-libiconv-prefix=DIR set correctly.

You can check that libiconv was found and used by the configure script by
examining config.h:

$ grep -i iconv build/include/config.h
/* Define if you have the iconv() function. */
/* #undef HAVE_ICONV */

2. "client charset" defined in freetds.conf for your dataserver.  

The value for "client charset" will be passed to libiconv.  I would expect
to see:

        client charset = ISO-8859-7

in your case.  

Contrary to our documentation, FreeTDS does not ask the OS for locale
information.  

HTH.

--jkl



The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above.  If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the
original message. Please note that we do not accept account orders and/or
instructions by e-mail, and therefore will not be responsible for carrying
out such orders and/or instructions.