Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rPPXZ-00BN3K-W6 for pgsql-general@arkaria.postgresql.org; Mon, 15 Jan 2024 16:10:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rPPXZ-00G7yL-3w for pgsql-general@arkaria.postgresql.org; Mon, 15 Jan 2024 16:10:21 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rPPXY-00G7yC-6W for pgsql-general@lists.postgresql.org; Mon, 15 Jan 2024 16:10:20 +0000 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rPPXU-001xML-Pj for pgsql-general@lists.postgresql.org; Mon, 15 Jan 2024 16:10:19 +0000 Received: from compute7.internal (compute7.nyi.internal [10.202.2.48]) by mailout.west.internal (Postfix) with ESMTP id 8980A3200AFD; Mon, 15 Jan 2024 11:10:13 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute7.internal (MEProxy); Mon, 15 Jan 2024 11:10:13 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm2; t=1705335013; x=1705421413; bh=LX/MEPJhwQYMTBMKqtA1qW72kY2QliNivLLbHFRuI2Q=; b= 2PdA+VTjUr/NkC9tBAsCQ8pHEtEg6WW5RT1YF0V8kWpX3lgYA3iZiFE1pNH8+MFj nYcrYXmrHKZB6bJ4jArex7Hp/xEWc02zXWIS8E1yOKTueoSklCV5onCGovEN1YkZ DoS8dbCDaXkrBALLn2z6eO8cRPf3MQ85xViQJglBBDlpvx1a/wJGZcMj+JOMsiKy MPn2h4QJaUmMXLDM5iGvKnzm7+ynHV5RygS6Vy/amlTZP/Upc9uw7VegJO54qH9U mT3jAmBfLYfQK65RLhwv/Y5IKti69AiqvPsUSe6kcrpEGnY7pII+yc3VGE2EXf53 MagWtPqz3ykUALhX1PnyiQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1705335013; x= 1705421413; bh=LX/MEPJhwQYMTBMKqtA1qW72kY2QliNivLLbHFRuI2Q=; b=N PsZT3jCPl5MLbenp3kkChRRXmCvLihCvqevLQWjqlPXZSgpR7TNUGvOKzXlM4T26 6VFrsW06tIGEhEdSXoyS0sWMghyQokKiwazOIlkJ1AM84pnpztD+iiGwKBIV6Eg6 +FHGofoETngFG0U2WuoL3uOGbLzYbWDhrJmJI6b0/tq59qnrKOZe2SjZn1TYiGOR KU8u26myoWns6t4J/dGmtRDFbcdClrt2YSbOt9g2nRAJieJX48c9Wfroh5uHOjvn UTLBfJ6pGy54pVjLY6yDwf31o+dM9ZymjIVn7kwm6aPKIrSIeMOHRjG2+gY48fGW Y30zLH2V2Ukg5ik86DHpw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedrvdejuddgkeeiucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepkfffgggfuffvfhfhjggtgfesthekredttddvjeenucfhrhhomheptegurhhi rghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtoh hmqeenucggtffrrghtthgvrhhnpeelveegueeggfelfeffhfevffdujeekvedvhfevteeu teduleekvdelgeeigfelkeenucffohhmrghinhepthhurhhkrdhnvghtnecuvehluhhsth gvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprggurhhirghnrdhklhgr vhgvrhesrghklhgrvhgvrhdrtghomh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 15 Jan 2024 11:10:12 -0500 (EST) Message-ID: Date: Mon, 15 Jan 2024 08:10:11 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: data migration using EXTENSION tds_fdw Content-Language: en-US To: =?UTF-8?Q?Ey=C3=BCp_Liste?= , "pgsql-general@lists.postgresql.org" References: From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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* ** > > > > *Eyüp Liste* > Technology > System And Infrastructure > -- Adrian Klaver adrian.klaver@aklaver.com