search

tds-fdw / tds_fdw

A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)
Other
381 stars 102 forks source link

Latin Characters in the value (e.g: ä, ö ) are not showing #183

Closed shashanknigam01 closed 6 years ago

shashanknigam01 commented 6 years ago

Hello,

When there are some Latin characters present in the string value of a column datatype as varchar in MSSQL database(e.g "hellö Jyväskylä"), then while querying that table via tds_fdw configured in PostgreSQL shows empty value in that column for that row.

Thanks, Shanks

shashanknigam01 commented 6 years ago

Hi,

There was an encoding issue which I fixed it by setting correct tds_version in the CREATE SERVER definition.

Thanks, Shanks