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 1vTKjX-00HaFL-1d for pgsql-admin@arkaria.postgresql.org; Wed, 10 Dec 2025 13:59:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vTKjW-00BlTr-0Q for pgsql-admin@arkaria.postgresql.org; Wed, 10 Dec 2025 13:59:58 +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 1vTKjV-00BlTi-2X for pgsql-admin@lists.postgresql.org; Wed, 10 Dec 2025 13:59:58 +0000 Received: from mail-oa1-x2d.google.com ([2001:4860:4864:20::2d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vTKjU-0048yZ-08 for pgsql-admin@lists.postgresql.org; Wed, 10 Dec 2025 13:59:56 +0000 Received: by mail-oa1-x2d.google.com with SMTP id 586e51a60fabf-3ec47e4c20eso4518541fac.1 for ; Wed, 10 Dec 2025 05:59:55 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1765375195; x=1765979995; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=eWtEXF2J8HFiW8jYGeTzMwrJ1vNpfwNLQD1ii+fLQTU=; b=lfUqwZdjpfgwgMsX+gFlv3+2wu9nGzYGXcBA6KPLOA4lcD1Uh2qx3nnu6RBT5kZ/ED H1WIER7B8wQhWW+Rb9AcdOWKZ5zdCoh3qRDiuk8VWUqZstlaF4IJOU0Zsx7RE/+1T4sb KXQF9X1rZuvIoOB8L99UPKXJEmYc4O6XAofanlEWGF7xF6pTjIlbhW37MGsLha0o5KGo UIYuxtkJbmKlYSp72SIIofqCSIinMtuyd3idYSoObELS6jPGPTP/WiSHhZe5QigHPE0f GbBO6Jl3uqytTLJWvuB3D0MEY5rGKJeaqCeOnAu4HjO/evBXjO0YJUHfB9fReJv2bfP0 WoTA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1765375195; x=1765979995; h=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=eWtEXF2J8HFiW8jYGeTzMwrJ1vNpfwNLQD1ii+fLQTU=; b=hRuzrF7rH6ohMR3MLxHH2eWrhUpo+jgM+LZ9ApHmuwuylRAhRJtbwQq8822s7TNnxc xZnm5IRlk7tuMT+yHIeuEiVoAYTwtyIV+lNQQce6ILmU7ytlBQBTGGxaIoVGlzdxTc7O meJgqpyQGmF+RQEC/mOhGjqKudpnZZ1EAhRSJ2tQnaqLWyjQO8UPIdt2MzfUQqa8Q2rM Nwtojyyw1qTFoNinyuC31yU62gJ8oEwvxCwuuucuuSJMppezxx01LbqJBBn0OB5NPY7F tz0kw47OFslNumNUSu6A+7NI78zqpZt8F7bhy8jY5twddba59ybN/VKVzI6k9EZOrae2 H7bw== X-Gm-Message-State: AOJu0YzE5U1uVXYMDs39Zg8zmgGvELniw4iUd5r/0uX6K9c/VGRtMipM QXiMDd6PxxxsXFy43Zi1fEAxkNoKLoZuAZiqhs28wwLD9tigrkGVYiFpdBjknPkuS1r5sQ8dC0c n8RyidVfTezUrM1Bnap5FwgjaMfR+yd0sKA== X-Gm-Gg: AY/fxX75DEFfLhzpTvz2DilPLbLNT2mc1oqCSvEoEG5sLyfpdMaPwssQS3hxR8rHEXT Lp5xXcMpUjT45A9iItZgPZH3S2d8/UfKwXx2ZNqhg/gUg3mejHpgQWpYgIZnSwvmHH3aiEgvBBV A3a87yJBLtFevuqJ59LhFI33Vek0fNLOPPv4Wc5sfAjkbqtc3v9Nm1K+zPddZLo4neJydSUMchy Y8FoRrnBbaZrXEFWBlE5CnFmi+vdgYrpxxlFqfR4kQ041WMqGhSRJIma14WCXoHB9J6A2hd X-Google-Smtp-Source: AGHT+IHZZXAVjBvPdkXQRcUT43haqos7iKqzuW2cXoTQjPaKar36+9r59j3S7Bd7YDc7SZ9oO/GBJdYhINHcuMk1uxE= X-Received: by 2002:a05:6870:9d1b:b0:3e8:5248:2f5b with SMTP id 586e51a60fabf-3f5bd8622a4mr1561624fac.18.1765375194792; Wed, 10 Dec 2025 05:59:54 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Wed, 10 Dec 2025 08:59:43 -0500 X-Gm-Features: AQt7F2ogKJxTgaX6_vxdXQvCl3TvhnzlNAAao0lzKG6Q-oIqSlyJAe_5azeUJ-8 Message-ID: Subject: Re: migrate oracle TH8TISASCII to postgres equivalnt win874 To: Pgsql-admin Content-Type: multipart/alternative; boundary="00000000000061892a06459971ac" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000061892a06459971ac Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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? --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --00000000000061892a06459971ac Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Dec 10, 2025 at 4:08=E2=80=AFAM T= zuriel Kahlon <tzuriel1986@gmai= l.com> wrote:
=
Hey Guys ,
im trying=C2=A0migrate DB from or= acle charset=C2=A0TH8TISASCII to postgres closed equivalent=C2=A0WIN874 , b= ut seems few chars 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 i= t in the oracle level 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> lobster!
--00000000000061892a06459971ac--