Skip to Content.
Sympa Menu

freetds - Re: [freetds] Charset option

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Andrew H. Wakefield" <a_wake AT earthlink.net>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Charset option
  • Date: Wed, 18 May 2011 10:37:34 -0400

Rather than setting your client charset to 8859-2, I wonder what would
happen if you set it to UTF-8?

On Wed, 2011-05-18 at 15:50 +0200, Dalibor Kušić wrote:
> Didn't help I'm afraid :( Problem is the same. I've noticed one interesting
> thing in the dump file. A letter U+0106 (UTF8 - C4 85) is displayed in the
> dump file as 06 01. But in the end result the character is U+00C4. It's
> like this character gets converted to UTF8 correctly (C485) and then for
> some reason it is assumed this is latin-1 and latin1 representation of C4
> is the U+00C4 character and latin1 of 85 is a control character. Or
> something like that :)
>
> Anyway here is the dump file:
> 15:27:37.036848 21550 (log.c:190):Starting log file for FreeTDS 0.82
> on 2011-05-18 15:27:37 with debug flags 0xffff.
> 15:27:37.036898 21550 (iconv.c:197):names for ISO-8859-1: ISO-8859-1
> 15:27:37.036905 21550 (iconv.c:197):names for UTF-8: UTF-8
> 15:27:37.036911 21550 (iconv.c:197):names for UCS-2LE: UCS-2LE
> 15:27:37.036917 21550 (iconv.c:197):names for UCS-2BE: UCS-2BE
> 15:27:37.036923 21550 (iconv.c:363):iconv to convert client-side data to
> the "ISO-8859-1" character set
> 15:27:37.036954 21550 (iconv.c:516):tds_iconv_info_init: converting
> "ISO-8859-1"->"UCS-2LE"
> 15:27:37.036982 21550 (iconv.c:516):tds_iconv_info_init: converting
> "ISO-8859-1"->"UCS-2LE"
>
> I'm worried about these lines that mention ISO-8859-1. Why is this here?
> Can the mistake be int he locales.conf file?
>
>
> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Igor Korot
> Sent: Tuesday, May 17, 2011 7:27 PM
> To: FreeTDS Development Group
> Subject: Re: [freetds] Charset option
>
> Dalibor
>
> 2011/5/17 Dalibor Kušić <Dalibor.Kusic AT in2.hr>:
> > I've debugged this to a point where I see that a correct stream in
> > UTF-16LE arrives from the SQL server and then iconv needs to convert this
> > to UTF-8 which is native to the unix system, but for some reason fails....
> > Here's a dump from the freetds log file:
> > Server charset: UCS-2LE
> > Server column_size: 510
> > Client charset: UTF-8
> > Client column_size: 1020
> >
> > Which shows these charsets.... Any ideas?
>
> Could you try to configure "--with-iconv=no", please?
>
> Thank you.
>
> >
> > Dalibor
> >
> > -----Original Message-----
> > From: freetds-bounces AT lists.ibiblio.org
> > [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Dalibor Kušić
> > Sent: Tuesday, May 17, 2011 1:40 PM
> > To: freetds AT lists.ibiblio.org
> > Subject: [freetds] Charset option
> >
> > Hi!
> >
> > I'm having trouble using freeTDS to talk to a MS SQL database with a
> > charset of CP1250. I can't achieve to see national characters when
> > executing a query using iSQL.
> >
> > I've downloaded and built from schratch the latest stable version of
> > FreeTDS. I've configured unixODBC and have put
> > Client charset = ISO-8859-2
> > in the freetds.conf file.
> >
> > However when I login to the database using iSQL and execute a query, I
> > see "?" instead of my national characters.....
> >
> > Dalibor Kušić
> >
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds






Archive powered by MHonArc 2.6.24.

Top of Page