Skip to Content.
Sympa Menu

freetds - Re: [freetds] Unable to connect to Sql Server via PHP when client chartset = CP1252

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] Unable to connect to Sql Server via PHP when client chartset = CP1252
  • Date: Mon, 21 Nov 2011 18:43:30 -0500

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




Archive powered by MHonArc 2.6.24.

Top of Page