Re: Charset option

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: [email protected] [mailto:[email protected]] 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ć <[email protected]>:
> > 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: [email protected] [mailto:[email protected]] On Behalf Of Dalibor Kušić
> > Sent: Tuesday, May 17, 2011 1:40 PM
> > To: [email protected]
> > 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
> > [email protected]
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> > _______________________________________________
> > FreeTDS mailing list
> > [email protected]
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds


_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds