Re: Unable to connect to Sql Server via PHP when client chartset = CP1252
"James K. Lowden" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
On Fri, 18 Nov 2011 17:32:43 +0000 (UTC) Chris Ballard <[email protected]> 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