Re: Cannot send UTF-8 chars to MSSQL 2008
"Craig A. Berry" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
On Jun 2, 2010, at 4:29 AM, Niklas Lampén wrote: >> -----Original Message----- >> From: [email protected] [mailto:freetds- >> [email protected]] On Behalf Of Daniel Fazekas >> Sent: 2. kesäkuuta 2010 11:47 >> >>> [AavaDb2] >>> host = ***** >>> client charset = UCS2 >> >> Simply change the client charset line to read UTF-8. >> > > Thank you for your reply. > > Unfortunately this did not solve my problem You might want to set TDSDUMPCONFIG and TDSDUMP in your environment and review the resulting logs to see what client character set you're actually getting. You might also try applying the patch from: <http://lists.ibiblio.org/pipermail/freetds/2010q2/026008.html> which I think should do a better job than the existing code at allowing freetds.conf to override the character set, though no guarantees it will work in your situation (however, it would be nice to have the confirmation if it does). I hope to get that patch checked in soonish, which could be a day or a week or ... ________________________________________ Craig A. Berry mailto:[email protected] "... getting out of a sonnet is much more difficult than getting in." Brad Leithauser