I don't think you are correct... UTF-8 might be default on MSSQL, but it is the ODBC
connection to PGSQL that sets the client encoding to UTF-8... (I.e. when I just connect to
the PGSQL server, I get a statement in the PG log file that says "set client_encoding to
'UTF8'..
And I don't want to use UNICODE on my PG Server....
BTJ
Ropel wrote:
> As far as I know, UTF-8 is the standard encoding used by MSSQL.
> ISO8859-1 /_is_ /LATIN1, so the system is trying to convert (as the
> error message says) from utf-8 (SqlServer) to ISO8859-1 ( LATIN1 ).
>
> So I think you have to search on the MSSQL side, not PostgreSql...
>
> You can also use UNICODE encoding on postgres, creating your DB with
> CREATE DATABASE mydb ENCODING='UNICODE';
>
> Hope this will give you some hints to solve the problem
>
> Regards,
> Roberto
>
>
> Bjørn T Johansen wrote:
>
>>I am trying to copy data from a MSSQL srv to PGSQL srv 8 using Delphi under Windows... But
>>I just keep getting this error... Why? (My PGSQL server is using LATIN1)
>>And how do I get around this?
>>
>>BTW; I see in the log for my PGSQL server that someone is setting Client encoding to
>>UTF-8, but I am not... Is this some default setting in pgodbc or? I can't find any place
>>to change this value....
>>
>>
>>Regards,
>>
>>BTJ
>>
>>
>>
>
