FreeTDS Development Group

["James K. Lowden" <jklowden AT freetds.org>]

On Fri, 18 Nov 2011 17:32:43 +0000 (UTC)
Chris Ballard <cballard AT datix.co.uk> wrote:

> We're experiencing problems saving some characters (e.g. ?) to the DB
> - they're entered as question marks.  
> 
> I've attempted to remedy this by adding a client charset definition,
> but setting this to CP1252 results in the connection to SQL Server
> not working at all.  

Are you linked to a real iconv library?  The built-in one won't handle
1252.  TDSDUMP is your friend there, also "tsql -C".  

Second, what collation are you using on the column holding the, ahem,
smart quotes?  Are those characters in fact part of that collation?  

--jkl