From: | rob stone <floriparob(at)gmail(dot)com> |
---|---|
To: | Juliano <jplinux(at)protonmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16) |
Date: | 2016-11-10 13:31:05 |
Message-ID: | 1478784665.2464.5.camel@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, 2016-11-10 at 05:34 -0500, Juliano wrote:
> Hi,
>
> I'm trying to import some data from a MS SQL Server 2014 sequential
> database to Postgresql using dbi-link.
>
> Postgresql 9.6 encoding is utf-8 and does not support utf-16 but, I
> need to transfer this data to postgres.
>
> I also tried to use tds_fdw version 1.0.8 and the same problem
> occurs.
>
> ERROR: DB-Library error: DB #: 100, DB Msg: TDS version downgraded to
> 7.1!, OS #: 0, OS Msg: Success, Level: 1
>
> ********** Error **********
>
> ERROR: DB-Library error: DB #: 100, DB Msg: TDS version downgraded to
> 7.1!, OS #: 0, OS Msg: Success, Level: 1
> SQL state: HV00L
>
> Please help me.
>
The error code HV00L means "unable to create execution".
This appears to have been fixed. See:-
https://github.com/tds-fdw/tds_fdw/issues/83
However, I don't follow "how" the UTF-16 data is being transformed to
UTF-8. I know that I'm thick (at times). If the SQL Server data is in
Simplified Chinese (say), how do you convert it?
Postgres handles some multi-byte codings:-
WIN932 --> SJIS
WIN936 --> GBK
WIN949 --> UHC
WIN950 --> BIG5
So you can run createdb specifying one of those encodings, lc_collate,
etc.
HTH,
Rob
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2016-11-10 14:31:16 | Re: Syncing Data of data type BLOB into Postgres- Bytea |
Previous Message | Tim Clarke | 2016-11-10 13:20:59 | Re: Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16) |