Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16)

Поиск
Список
Период
Сортировка
От Juliano
Тема Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16)
Дата
Msg-id bJkVbjssxqTQaXlGXyKuRbuozh2DxsJhamIT2vnctB-dFn59qPaSmHjuCRQ7s7xUMlj-kpbXGFlEfp2jbBWXwBA9zmKQP895yrhGErVpbLs=@protonmail.com
обсуждение исходный текст
Ответы Re: Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16)
Re: Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16)
Список pgsql-general

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.


В списке pgsql-general по дате отправления:

Предыдущее
От: Samuel Williams
Дата:
Сообщение: Re: initdb createuser commands
Следующее
От: Raymond O'Donnell
Дата:
Сообщение: Re: Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16)