pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
data 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