FreeTDS Development Group

[Dalibor Kušić <Dalibor.Kusic AT in2.hr>]

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