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 1rPpbJ-00EUyM-7k for pgsql-general@arkaria.postgresql.org; Tue, 16 Jan 2024 19:59:57 +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 1rPpbI-007BMg-9k for pgsql-general@arkaria.postgresql.org; Tue, 16 Jan 2024 19:59:56 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rPpbH-007BLu-Mx for pgsql-general@lists.postgresql.org; Tue, 16 Jan 2024 19:59:55 +0000 Received: from mail-oi1-x232.google.com ([2607:f8b0:4864:20::232]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rPpbF-001rof-5P for pgsql-general@lists.postgresql.org; Tue, 16 Jan 2024 19:59:54 +0000 Received: by mail-oi1-x232.google.com with SMTP id 5614622812f47-3bd67e9d6ceso2070162b6e.3 for ; Tue, 16 Jan 2024 11:59:53 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1705435192; x=1706039992; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=HY7SoPwJLL412XsosAvaUEpPHGb1f/ZZBSsvmFXgepI=; b=HYuX912yNwoZfkFSur+MrA+ZhEdWQP65cBeEb9QeJasxRtGUgm7NVxausvglZmd1Fs a9fY/DLVMRaM6Rf4U+wb884mcxaa12Pq4ri26wM2F9Vymon8K0DaaxyHBF0Ks2rdxuhq kyh8DdzpYHWMz5HC36I/dS5qWMkCO2FIxacnrotA8Fzr7LmKfZQOswTqSDlqqqAj5imq /ucL6+xaeDw8t42/ememXo2sBLMDbx5YDEYHVS8gRALOYJmhoN0QTPISy0+ZAogn+73r pmc8g5QlBAlW8oElr5hVU82vImPi4F1igBYQkcWDBPFWh8NYm4qGKyPuJvEKSxYnXS+C /SNg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1705435192; x=1706039992; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=HY7SoPwJLL412XsosAvaUEpPHGb1f/ZZBSsvmFXgepI=; b=VZXx2qHtHpxa3jXoa5301GFTquXyZwMb3R68+OppMrX8o6kxjoDpyJjLOsqRsDDSIH HDP72cHZXWBDtbUUCKVNtB1GZa2c8sybMHRN2wAHkU6bJp/rJxUDDCE0Ms4dIuuBUDes b2At7y2B8Z0xXWrHLycDUcmjnu/tLclC6uLPzvtD+XbZKfU0LDGy0CxEm2ZiYg2qxS41 RtQayCTiItMKc+rxar5lN5a/Al3qDxYb7dJllXYub/J/F+XSXV346rQZhcF+7dpYNtq3 8Z/fCa2g8VXrEmSqs9z2oGs+DeFSt7P8hNFb9WiM3n2YFezu4qOo9fCIWXRaoCh4qR86 SuSQ== X-Gm-Message-State: AOJu0YwneDmLb2NkZoCziiNGfg2/GAFZlwG4XS2kICQAluYVbml/rE43 kZTpdDFUnMkIiSMYWSR4Tw== X-Google-Smtp-Source: AGHT+IEJzvXDo8iFGuAs9Rzg/XdC6AZZfBfdSsJOBhpyqvkAXaOjBq2ZkmukdWQq21/0QqNASzcEdQ== X-Received: by 2002:a05:6808:2e95:b0:3bd:470e:c836 with SMTP id gt21-20020a0568082e9500b003bd470ec836mr11060644oib.32.1705435192498; Tue, 16 Jan 2024 11:59:52 -0800 (PST) Received: from [192.168.2.16] (070-113-014-216.res.spectrum.com. [70.113.14.216]) by smtp.gmail.com with ESMTPSA id ct11-20020a056808360b00b003bd8a7953a5sm298867oib.19.2024.01.16.11.59.51 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 16 Jan 2024 11:59:52 -0800 (PST) Message-ID: <617c1d7e-8b4e-4765-82a8-2e69acfd42c3@gmail.com> Date: Tue, 16 Jan 2024 13:59:49 -0600 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: data migration using EXTENSION tds_fdw Content-Language: en-US To: Adrian Klaver , =?UTF-8?Q?Ey=C3=BCp_Liste?= , "pgsql-general@lists.postgresql.org" References: From: Jim Nasby In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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