[freetds] SQL Server version and TDS Version
Vinh Nguyen
vinhdizzo at gmail.com
Tue Apr 20 13:27:15 EDT 2010
On Mon, Apr 19, 2010 at 7:55 AM, Vinh Nguyen <vinhdizzo at gmail.com> wrote:
> $ which iconv
> /opt/local/bin/iconv
>
> based upon the location, iconv came from Macports. Should I be using
> another version?
>
>> > I think FreeTDS doesn't know the encoding, decides it's "probably" ISO
>> > 8859-1 (wrongly) and mis-encodes something in your login packet,
>> > causing
>> > the server to reject it.
>>
>> Here are the options I see for Mac OS X (Leopard PPC, if it matters):
>>
>> % iconv -l | grep -i utf\.8
>> UTF-8 UTF8
>> UTF-8-MAC UTF8-MAC
>>
>> So the question probably is who or what thinks it wants utf-8 rather
>> than UTF-8? If that setting came from a freetds.conf, the answer is
>> easy -- don't do that. If it's a default chosen by FreeTDS, that
>> surprises me because I though all of the common mappings had long
>> since been worked out.
>
>
> I'm on snow leopard intel and I get:
> ~$ iconv -l | grep -i utf\.8
> UTF-8
> UTF-8-MAC UTF8-MAC
>
> I'm not familiar with the iconv stuff, so it shouldn't be showing
> UTF-8? What then should it be? Any suggestions on a fix? Can I
> specify a in freetds.conf?
I also found a local version of iconv on my mac system:
/usr/bin/iconv -l | grep -i utf\.8
UTF-8 UTF8
UTF-8-MAC UTF8-MAC
So what exactly is the issue again? Is there a difference between
utf-8 and UTF-8? I'd appreciate any help so I can continue
investigating. Thanks.
More information about the FreeTDS
mailing list