[freetds] Possible bug with extended ASCII

Lowden, James K LowdenJK at bernstein.com
Fri May 9 11:10:06 EDT 2003

> Date: Thu, 8 May 2003 17:17:23 -0600
> From: Craig Davison <cd at securityfocus.com>
> After I upgraded to freetds 0.61 from 0.60, I noticed that queries that 
> contained extended ASCII characters would fail.
> Here's an example query that should return an empty rowset if it succeeds:
> select uid from master..sysusers where name = 'Ã'
> The character between the '' is Ã, the capital A tilde character. You can 
> type it with Alt-195 on a PC.
> ...
> Was this never a valid character to have in a query, or was there a bug 
> introduced sometime between freetds 0.60 and 0.61?

It's a valid query.  You can put absolutely anything between single quotes.

FreeTDS is apparently not recognizing your client character set; that would 
cause it to substitute a '?' (no quotes) for the 'Ã'.  Does the log show 
anything suspicious?  

I'll have a look at this over the weekend.  Frediano asked me to repackage 
0.61 with some updates.  I'd like to fix or at least document this 
behavior in 0.61[.1] if I can confirm it.  

We should have a unit test for this....


The information contained in this transmission may contain privileged and
confidential information 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.

More information about the FreeTDS mailing list