pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feeddata migration using EXTENSION tds_fdw
5+ messages / 3 participants
[nested] [flat]
* data migration using EXTENSION tds_fdw
@ 2024-01-14 18:55 Eyüp Liste <eyup.liste@turk.net>
2024-01-15 16:10 ` Re: data migration using EXTENSION tds_fdw Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 1 reply; 5+ messages in thread
From: Eyüp Liste @ 2024-01-14 18:55 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Hello,
I have worked on migrate a table from sql server 2017 to postgresql 15 . Ý have completed all steps. But when i try to migrate some columns , i got error;
NOTICE: tds_fdw: Query executed correctly NOTICE: tds_fdw: Getting results ERROR: DB-Library error: DB #: 2403, DB Msg: Some character(s) could not be converted into client's character set. Unconverted bytes were changed to question marks ('?'), OS #: 0, OS Msg: Success, Level: 4 SQL state: HV00L
Please help me about this issue.
Best regards
[turknet-logo]<https://turk.net/;
Eyüp Liste
Technology
System And Infrastructure
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: data migration using EXTENSION tds_fdw
2024-01-14 18:55 data migration using EXTENSION tds_fdw Eyüp Liste <eyup.liste@turk.net>
@ 2024-01-15 16:10 ` Adrian Klaver <adrian.klaver@aklaver.com>
2024-01-15 19:03 ` RE: data migration using EXTENSION tds_fdw Eyüp Liste <eyup.liste@turk.net>
0 siblings, 1 reply; 5+ messages in thread
From: Adrian Klaver @ 2024-01-15 16:10 UTC (permalink / raw)
To: Eyüp Liste <eyup.liste@turk.net>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
On 1/14/24 10:55, Eyüp Liste wrote:
> Hello,
>
> I have worked on migrate a table from sql server 2017 to postgresql 15 .
> İ have completed all steps. But when i try to migrate some columns , i
> got error;
>
> NOTICE: tds_fdw: Query executed correctly NOTICE: tds_fdw: Getting
> results ERROR: DB-Library error: DB #: 2403, DB Msg: Some character(s)
> could not be converted into client's character set. Unconverted bytes
> were changed to question marks ('?'), OS #: 0, OS Msg: Success, Level: 4
> SQL state: HV00L
This "Some character(s) could not be converted into client's character
set." would seem to be the issue.
Therefore what is the character set used in the?:
1) The SQL Server database.
2) The Postgres database
>
> Please help me about this issue.
>
> Best regards
>
> *turknet-logo* <https://turk.net/>**
>
>
>
> *Eyüp Liste*
> Technology
> System And Infrastructure
>
--
Adrian Klaver
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: data migration using EXTENSION tds_fdw
2024-01-14 18:55 data migration using EXTENSION tds_fdw Eyüp Liste <eyup.liste@turk.net>
2024-01-15 16:10 ` Re: data migration using EXTENSION tds_fdw Adrian Klaver <adrian.klaver@aklaver.com>
@ 2024-01-15 19:03 ` Eyüp Liste <eyup.liste@turk.net>
2024-01-15 19:17 ` Re: data migration using EXTENSION tds_fdw Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 1 reply; 5+ messages in thread
From: Eyüp Liste @ 2024-01-15 19:03 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Hello,
1)TURKISH_CI_AS at sql server database
2)Encoding : UTF8 Collate: en_US.UTF-8 at Postgresql
Thank u for fast response
Best Regards
Eyup Liste
Senior Database Administrator
___________________________________________________________
TurkNet Iletisim
M: +905452120762
E: eyup.liste@turk.net
-----Original Message-----
From: Adrian Klaver <adrian.klaver@aklaver.com>
Sent: Monday, January 15, 2024 7:10 PM
To: Eyüp Liste <eyup.liste@turk.net>; pgsql-general@lists.postgresql.org
Subject: Re: data migration using EXTENSION tds_fdw
[UYARI] Bu ileti TurkNet dışından gönderildi. Lütfen gönderen adresleri kontrol edin ve ekleri açmadan önce dikkatli olun.
Spam/phishing olduğunu düşündüğünüz mailler için spambildir@turknet.net.tr<mailto:spambildir@turknet.net.tr> adresine bilgi verebilirsiniz.
On 1/14/24 10:55, Eyüp Liste wrote:
> Hello,
>
> I have worked on migrate a table from sql server 2017 to postgresql 15 .
> İ have completed all steps. But when i try to migrate some columns , i
> got error;
>
> NOTICE: tds_fdw: Query executed correctly NOTICE: tds_fdw: Getting
> results ERROR: DB-Library error: DB #: 2403, DB Msg: Some character(s)
> could not be converted into client's character set. Unconverted bytes
> were changed to question marks ('?'), OS #: 0, OS Msg: Success, Level:
> 4 SQL state: HV00L
This "Some character(s) could not be converted into client's character set." would seem to be the issue.
Therefore what is the character set used in the?:
1) The SQL Server database.
2) The Postgres database
>
> Please help me about this issue.
>
> Best regards
>
> *turknet-logo* <https://turk.net/>**
>
>
>
> *Eyüp Liste*
> Technology
> System And Infrastructure
>
--
Adrian Klaver
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: data migration using EXTENSION tds_fdw
2024-01-14 18:55 data migration using EXTENSION tds_fdw Eyüp Liste <eyup.liste@turk.net>
2024-01-15 16:10 ` Re: data migration using EXTENSION tds_fdw Adrian Klaver <adrian.klaver@aklaver.com>
2024-01-15 19:03 ` RE: data migration using EXTENSION tds_fdw Eyüp Liste <eyup.liste@turk.net>
@ 2024-01-15 19:17 ` Adrian Klaver <adrian.klaver@aklaver.com>
2024-01-16 19:59 ` Re: data migration using EXTENSION tds_fdw Jim Nasby <jim.nasby@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Adrian Klaver @ 2024-01-15 19:17 UTC (permalink / raw)
To: Eyüp Liste <eyup.liste@turk.net>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
On 1/15/24 11:03 AM, Eyüp Liste wrote:
> Hello,
>
> 1)TURKISH_CI_AS at sql server database
>
> 2)Encoding : UTF8 Collate: en_US.UTF-8 at Postgresql
I don't use tds_fdw, so the best I can do is point you at information
Hopefully someone with practical experience will chime in with more
specific information.
The information I could find is:
https://www.freetds.org/userguide/configs.html#Localization
>
> Thank u for fast response
>
> Best Regards
>
> Eyup Liste
> Senior Database Administrator
> ___________________________________________________________
>
> TurkNet Iletisim
>
>
>
>
>
>
>
> M: +905452120762
> E: eyup.liste@turk.net
>
> -----Original Message-----
> From: Adrian Klaver <adrian.klaver@aklaver.com>
> Sent: Monday, January 15, 2024 7:10 PM
> To: Eyüp Liste <eyup.liste@turk.net>; pgsql-general@lists.postgresql.org
> Subject: Re: data migration using EXTENSION tds_fdw
>
>
> [UYARI] Bu ileti TurkNet dışından gönderildi. Lütfen gönderen adresleri kontrol edin ve ekleri açmadan önce dikkatli olun.
> Spam/phishing olduğunu düşündüğünüz mailler için spambildir@turknet.net.tr<mailto:spambildir@turknet.net.tr> adresine bilgi verebilirsiniz.
>
>
> On 1/14/24 10:55, Eyüp Liste wrote:
>> Hello,
>>
>> I have worked on migrate a table from sql server 2017 to postgresql 15 .
>> İ have completed all steps. But when i try to migrate some columns , i
>> got error;
>>
>> NOTICE: tds_fdw: Query executed correctly NOTICE: tds_fdw: Getting
>> results ERROR: DB-Library error: DB #: 2403, DB Msg: Some character(s)
>> could not be converted into client's character set. Unconverted bytes
>> were changed to question marks ('?'), OS #: 0, OS Msg: Success, Level:
>> 4 SQL state: HV00L
> This "Some character(s) could not be converted into client's character set." would seem to be the issue.
>
> Therefore what is the character set used in the?:
>
> 1) The SQL Server database.
>
> 2) The Postgres database
>
>> Please help me about this issue.
>>
>> Best regards
>>
>> *turknet-logo* <https://turk.net/>**
>>
>>
>>
>> *Eyüp Liste*
>> Technology
>> System And Infrastructure
>>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: data migration using EXTENSION tds_fdw
2024-01-14 18:55 data migration using EXTENSION tds_fdw Eyüp Liste <eyup.liste@turk.net>
2024-01-15 16:10 ` Re: data migration using EXTENSION tds_fdw Adrian Klaver <adrian.klaver@aklaver.com>
2024-01-15 19:03 ` RE: data migration using EXTENSION tds_fdw Eyüp Liste <eyup.liste@turk.net>
2024-01-15 19:17 ` Re: data migration using EXTENSION tds_fdw Adrian Klaver <adrian.klaver@aklaver.com>
@ 2024-01-16 19:59 ` Jim Nasby <jim.nasby@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Jim Nasby @ 2024-01-16 19:59 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; Eyüp Liste <eyup.liste@turk.net>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
On 1/15/24 1:17 PM, Adrian Klaver wrote:
>
> I don't use tds_fdw, so the best I can do is point you at information
>
> Hopefully someone with practical experience will chime in with more
> specific information.
>
> The information I could find is:
>
> https://www.freetds.org/userguide/configs.html#Localization
One other UTF8 "gotcha" in Postgres that may or may not be relevant
here: UTF8 considers the value 0 (as in a 0 byte; not the glyph "0") to
be a legit character, but for various reasons Postgres can't actually
support that, so trying to insert into a text/varchar/char field in PG
will give you an error (not sure what exact error you'd get though).
--
Jim Nasby, Data Architect, Austin TX
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2024-01-16 19:59 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-01-14 18:55 data migration using EXTENSION tds_fdw Eyüp Liste <eyup.liste@turk.net>
2024-01-15 16:10 ` Adrian Klaver <adrian.klaver@aklaver.com>
2024-01-15 19:03 ` Eyüp Liste <eyup.liste@turk.net>
2024-01-15 19:17 ` Adrian Klaver <adrian.klaver@aklaver.com>
2024-01-16 19:59 ` Jim Nasby <jim.nasby@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox