I have linked a SQL Server database with a PostgreSQL database via tds_fdw
extension .
I mapped SQL Server tables into PostgreSQL foreign tables. Connection successfully.
I have got problem on mapping nvarchar
datatype to Postgres. I mapped nvarchar
as varchar
, because SQL Server varchar
and nvarchar
is the same for PostgreSQL. But nvarchar
columns didn't mapped correctly (stored as ?
for some symbols).
How can I correctly map nvarchar
from SQL Server to an equivalent datatype in Postgresql ?
I created Postgresql database with an UTF8 encoding