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.96) (envelope-from ) id 1vTKtl-000538-1E for pgsql-admin@arkaria.postgresql.org; Wed, 10 Dec 2025 14:10:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vTKtj-00BtPY-0Q for pgsql-admin@arkaria.postgresql.org; Wed, 10 Dec 2025 14:10:31 +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.96) (envelope-from ) id 1vTKti-00BtPQ-2a for pgsql-admin@lists.postgresql.org; Wed, 10 Dec 2025 14:10:31 +0000 Received: from mail-dy1-x1333.google.com ([2607:f8b0:4864:20::1333]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vTKth-00492z-0V for pgsql-admin@lists.postgresql.org; Wed, 10 Dec 2025 14:10:30 +0000 Received: by mail-dy1-x1333.google.com with SMTP id 5a478bee46e88-2a484a0b7cfso1058745eec.1 for ; Wed, 10 Dec 2025 06:10:29 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1765375828; x=1765980628; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=Y6NZDZw87Y9O32dh5oI1hUZDh//incm1TI2HR+hWL6o=; b=GD2UOfFr8JZFZSPzQfieW6Oz3O7Q6mhTkFQfw+Blb0OPWcaXC0+fqz2K2OaEnB1W7D +deMhIlu/5semFHMQjUEQbMf2+jsxZvw7llK67XNw6eoqdbPlOe2JcSWSkEMZV9ZrwrF a8sh5O+uwDh6jNyCmobuWYdtso4UkxS3ngHsWfy4okU8qpIodlwp3g66K2poXbMoQJft qcHhh5pRdOCEi0/hRUJN7nb53nteZ85NuCWPs2oixbTzRLWF/Sg97gPOvtVrIQTNpBJA HNS0tMSPgd4KBRUt4Ma/eUc9Urfr8kCnxBCBNG6EsYpf4MMuqFcUu4zc9nABNaTvx0kO 1bmA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1765375828; x=1765980628; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=Y6NZDZw87Y9O32dh5oI1hUZDh//incm1TI2HR+hWL6o=; b=Zf4ETE268eFZNDAJGUuzc5BAqMh3n2e43zHBQgx6I9EHu/+2wbeAiKrXI30S80q2hk NjR9tqnPP6ou1FI1Rs/q+cpXxi73EJKQOq23owO03Ov7CbYxMKmv88vTj4UxI4X8k8mQ 2LH4HpLUcbl2V1wCjO1IzePRlN8+wxl2d+m/uUFV8vUa0j7GcuTsfIU/T0MruXS+7ZjZ pRfEDrKvZIhMWJTyJpsU5JmgQl+aIAir6FTV8UNbXqqNDSrHdumzm7iJHKyCLi7NVsZs 3L+LAprgbsBK4UGCMsrOpuDDZMOSU8olcpe98G8QoEkcVw83MSe9zP31XxHwQ34ptzl0 zOqw== X-Gm-Message-State: AOJu0YxZm5qetg+LDuy/onKclmsa7j7hsDBP4XJiPUZ10cdgnu+5J/Vc MqrOEI89Bjz00alH3u82wHXDpQnqb/AFRLTSaknsczSUlcVFH66nTBV0pvxFSXk0tp71an0SZvi 1UZL2XWvlCoAiEfb9oqEX9GyRe7rhVQ== X-Gm-Gg: AY/fxX76BtAXrFJhvral977jZoT1AIc0iAIzfNgt9DGialBXH95CJyjDlMt6h9D9+JK tQz2BEXY4X0Zo3/XAUM8+f+Q3i3NgqJP1wSSxcDu/LEtSR/TGIkyS8NgxnfZPDIDxELfkqxJ3Bn oIphCJmeh3LLAcknrl+gz0SRcpTdIIVfAnE9sYyWtaFUuj/qmAZaBi8AyJOqMWER5dbKxktR4IH Fj3AotM0QBZwK4GvY5AnG4BGi6wGDxQPOmc/VCWnceKfOisCxSCaIZCpOPGbQ/1IoKOJZkYQUGv AR8SqBzKnCuBTf9iroqDG/T/gHCBopL6ciVoEA== X-Google-Smtp-Source: AGHT+IFyEV35rRr2d484LmvK/WNFU5n447y5rKGnGnC2Zp3N7Y+ZeHTGUZFFV5QUZH8027ZkZmPL4bQfF5BSoCQ8pmI= X-Received: by 2002:a05:7301:f25:b0:2a4:50c2:a74c with SMTP id 5a478bee46e88-2abf8dee655mr2604364eec.8.1765375828124; Wed, 10 Dec 2025 06:10:28 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Tzuriel Kahlon Date: Wed, 10 Dec 2025 16:10:15 +0200 X-Gm-Features: AQt7F2pz27EOucQ_cel3Bagvvn5gh0QtJ9FgdZOs3PVCUGeMEqHXkhQBuf2EKlc Message-ID: Subject: Re: migrate oracle TH8TISASCII to postgres equivalnt win874 To: Ron Johnson Cc: Pgsql-admin Content-Type: multipart/alternative; boundary="00000000000021698d0645999703" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000021698d0645999703 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hey , Since we are retrieving from middleware like cics that have encoding win874= . *=D7=91=D7=91=D7=A8=D7=9B=D7=94 * *=D7=A6=D7=95=D7=A8=D7=99=D7=90=D7=9C =D7=9B=D7=97=D7=9C=D7=95=D7=9F * 0523851143 On Wed, Dec 10, 2025, 16:00 Ron Johnson wrote: > On Wed, Dec 10, 2025 at 4:08=E2=80=AFAM Tzuriel Kahlon > wrote: > >> Hey Guys , >> im trying migrate DB from oracle charset TH8TISASCII to postgres closed >> equivalent WIN874 , but seems few chars are not transferred successfully= . >> >> 1. do you know which characters are not fully covered in win874 when >> converting from TH8TISASCII. >> >> 2. how do i fetch it in the oracle level before doing the migrate ? >> > > Out of curiosity, why not UTF8? > > -- > Death to , and butter sauce. > Don't boil me, I'm still alive. > lobster! > --00000000000021698d0645999703 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hey ,=C2=A0

Since we are retrieving from middleware like cics that have enco= ding win874.




=D7=91=D7=91=D7=A8= =D7=9B=D7=94=C2=A0
=D7=A6=D7=95=D7=A8=D7=99=D7=90=D7=9C = =D7=9B=D7=97=D7=9C=D7=95=D7=9F=C2=A0
0523851143

On Wed, Dec 10, 2025, 16:00 Ron Johnson <ronljohnsonjr@gmail.com> wrote= :
On Wed, Dec 10, 2025 at 4:08=E2=80=AFAM Tzuriel Kahlon <tzuriel1986@= gmail.com> wrote:
Hey Guys= ,
im trying=C2=A0migrate DB from oracle charset=C2= =A0TH8TISASCII to postgres closed equivalent=C2=A0WIN874 , but seems few ch= ars are not transferred=C2=A0successfully=C2=A0 .
1. do you know which characters=C2=A0are not fully = covered in win874 when converting from=C2=A0TH8TISASCII.=C2=A0

2. how do i fetch it in the oracle lev= el before doing the migrate ?=C2=A0

=
Out of curiosity, why not UTF8?

--
Death to <Redacted>, and butter sauce.Don't boil me, I'm still alive.
<Redacted> lobs= ter!
--00000000000021698d0645999703--