FreeTDS Development Group

["Lowden, James K" <james.k.lowden AT alliancebernstein.com>]

> From: jack brack
> Sent: Thursday, April 13, 2006 3:30 AM
> From: james.k.lowden AT alliancebernstein.com
> >> 
> >>> Turn on TDSDUMPCONFIG to confirm it's being used.
> 
> It is, but the packet dump disagrees.
> 
> TDSDUMPCONFIG says:
>  option = 'client charset' value = 'iso_1'.
>  tds_config_login:453: client charset is iso_1.
> 
> TDSDUMP says:
>  names for ISO-8859-1: ISO-8859-1
>  names for UTF-8: UTF-8
>  names for UCS-2LE: UCS-2LE
>  names for UCS-2BE: UCS-2BE
>  iconv to convert client-side data to the "UTF-8" character set
>  tds_iconv_info_init: converting "UTF-8"->"UCS-2LE"
> [snip]
> 01c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........
........|
> 01d0 00 0c 05 00 00 00 43 54-2d 4c 69 62 72 61 72 79 |......CT
-Library|
> 01e0 0a 05 00 00 00 00 0d 11-65 6e 67 6c 69 73 68 00 |........
english.|
> 01f0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........
........|
> 
> 16:32:00.409751 Sending packet
> 0000 02 01 00 61 00 00 00 00-00 00 00 00 00 00 07 00 |...a....
........|
> 0010 00 00 00 00 00 00 00 00-00 00 00 00 00 55 54 46 |........
.....UTF|
> 0020 2d 38 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |-8......
........|
> 0030 00 00 00 00 00 00 00 00-00 00 00 05 01 35 31 32 |........
.....512|
> 
> So UTF-8 gets in there somehow.
...
> If I run
>  unset LANG
> then the login is attempted with ANSI_X3.4-1968:
...
> Ack!

Hi Jack, 

Ack, indeed.  I'm forming a theory I don't like, and I wonder if you
would try something for me?  

IIRC, you're running this under PHP with sybase extensions, using
ct-lib.  I wonder if something in the ct-lib initialization overrides
your settings somehow.  To find out, I'd like to try a few other ways,
to see if we can isolate the module that's insisting on UTF-8.  

Please use TDSDUMP with:

        tsql
        bsqldb 
        src/ctlib/unittests/t0001.c

There are three possible outcomes:

1.  all of them log in as UTF-8
2.  none of them log in as UTF-8
3.  only the unit test logs in as UTF-8

If the first, then I don't understand.  If the second, it's something in
PHP.  If the third, well, it's something in ct-lib.  

Thank you for your persistence and care.  One of us will surely learn
something, eventually.  

Regards,

--jkl




-----------------------------------------
The information contained in this transmission may be privileged and
confidential 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.  If you, as the intended 
recipient
of this message, the purpose of which is to inform and update our clients, 
prospects
and consultants of developments relating to our services and products, would 
not
like to receive further e-mail correspondence from the sender, please "reply" 
to the
sender indicating your wishes.  In the U.S.: 1345 Avenue of the Americas, New 
York,
NY 10105.