Skip to Content.
Sympa Menu

freetds - Re: [freetds] Charset option

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Dalibor Kušić <Dalibor.Kusic AT in2.hr>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Charset option
  • Date: Wed, 18 May 2011 15:50:36 +0200

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



Archive powered by MHonArc 2.6.24.

Top of Page