Re: UTF-8 on Windows XP
"James K. Lowden" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
On Thu, 23 Jun 2011 13:35:53 +0300 Cavit Cahit VURAL <[email protected]> wrote: > The string fields in all tables are NVARCHAR and LINUX has no problem > with UTF-8 encoding. It's writing and reading very well. > > We compiled freetds-0.92.dev.20110619 on Windows XP with MSyS and > Mingw. It worked and connected to the server. > > But on Windows XP it converts the strings in NVARCHARS fields to > ISO-8859-1. > > Tried to set client charset to UTF-8 by freetds.conf but it has no > affects. http://www.freetds.org/91/userguide/odbcconnattr.htm Probably you want to use the new ClientCharset ODBC connection attribute, see link above. If you're using Server, not Servername, in your DSN or connection string, the driver never sees freetds.conf. You can use src/apps/osql to verify that. HTH. --jkl