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@xxxxxxxx -----Original Message----- From: Adrian Klaver <adrian.klaver@xxxxxxxxxxx> Sent: Monday, January 15, 2024 7:10 PM To: Eyüp Liste <eyup.liste@xxxxxxxx>; pgsql-general@xxxxxxxxxxxxxxxxxxxx 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@xxxxxxxxxxxxxx<mailto:spambildir@xxxxxxxxxxxxxx> 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@xxxxxxxxxxx
