Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pcCFK-0001jy-Br for pgsql-admin@arkaria.postgresql.org; Tue, 14 Mar 2023 21:31:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pcCFJ-00041U-8d for pgsql-admin@arkaria.postgresql.org; Tue, 14 Mar 2023 21:31:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pcCFI-00041K-QW for pgsql-admin@lists.postgresql.org; Tue, 14 Mar 2023 21:31:48 +0000 Received: from mail-ed1-x543.google.com ([2a00:1450:4864:20::543]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pcCFE-0000sh-HT for pgsql-admin@lists.postgresql.org; Tue, 14 Mar 2023 21:31:48 +0000 Received: by mail-ed1-x543.google.com with SMTP id da10so67850313edb.3 for ; Tue, 14 Mar 2023 14:31:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; t=1678829503; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=HnTvv6OE27v9rpXLN8cUlCS9p6QRKGAnK7B4hRqavBo=; b=bKzYvWyuDB5HF10ermCVYmiws9fPgPHV2JdHQzn6x/noEXJ9E0UBrqdRo6ZyFndQDM ed3lShr2xDMCQM1aSsCQ+WnMGrT/Zya9zOPGoP9qioL7Y5XJpkpDFHnYCIod1v10Mm1+ u2ajBYKpslEXOI08K2WxlwMN7N4ann/PORjtmo+DMIe73+O7myqfQybdUacfZCv9bL7k jkyupJBcXyLSxZJnqqoFZ+qnPzJiEMap6hhqzYY5AAy5b/ExsgaMR2n3ZvAlDB/msYXS 3X1SPfqZXYAqPJnPR2fjjLoBlxgbm2WAr/1Ge9P8Qy8ieBM2Jc07whMwEuXz8vTyScPr XRPg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1678829503; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=HnTvv6OE27v9rpXLN8cUlCS9p6QRKGAnK7B4hRqavBo=; b=8Kd92pdVJBYdYgBMbpyutQ8FHGu6+JdqIErOo2xurU9YiMiz0Sd1ozUb1/wZhXuSM6 SlhzAwGAy7oMcP+8VWkI2Q2nouimAxnEmhDmlM5Mdb8J+4kxW3LKdvKE9NqmBtD6YGpL rKkSZUMnwHNe4+34LFqmEJQLL2NOwzm89YwszS15boRVFLQNsK9NSmSXvnYfMkBhIIR7 c6k/7uEA5zEQxkfF2pTwMia2M6VK/h39NG6V8mry2UDHXuET12/baWkT+CDImt7sZcgC wyCdptAH13t0zzJL/jFGZQ7Hmb8shG2uJyaVn0gNA7bn97/PwstNJDU/k1Pxd4dJuaDV Iy3A== X-Gm-Message-State: AO0yUKVOhmtCdF5+dx8cpKSUvYpvmMJgEboq9oZ2aCBrunRIRXAkiiKm cjTeN20W89Mr3MC//t7xcon+KQ== X-Google-Smtp-Source: AK7set/kEeSNFpWXQlrBUpwUQj+h4j9/fyM8mjH57PQtFsAUONM2BaywLxANGx3hygyBefn1W21C1A== X-Received: by 2002:a17:907:7609:b0:925:a96a:8b98 with SMTP id jx9-20020a170907760900b00925a96a8b98mr3816967ejc.67.1678829503203; Tue, 14 Mar 2023 14:31:43 -0700 (PDT) Received: from localhost.localdomain (p50992f7c.dip0.t-ipconnect.de. [80.153.47.124]) by smtp.gmail.com with ESMTPSA id og49-20020a1709071df100b0090953b9da51sm1598118ejc.194.2023.03.14.14.31.41 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 14 Mar 2023 14:31:42 -0700 (PDT) Message-ID: <2eac4511bf140cbbf926cf84010f4f2c8ce0c62c.camel@cybertec.at> Subject: Re: Oracle characterset and collation to Postgresql From: Laurenz Albe To: "James Pang (chaolpan)" , "pgsql-admin@lists.postgresql.org" Date: Tue, 14 Mar 2023 22:31:39 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.46.4 (3.46.4-1.fc37) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 2023-03-14 at 07:25 +0000, James Pang (chaolpan) wrote: > Hi, > We plan to migrate from Oracle to Postgresql 14.=C2=A0 Oracle AL32UTF8 ,= =C2=A0 collate BINARY, > migrate to Postgresql ,=C2=A0 database encoding UTF8,=C2=A0=C2=A0=C2=A0 c= ollate=C2=A0 is =E2=80=9CC=E2=80=9D or =E2=80=9CC.UTF8=E2=80=9D ? > Any key difference between collate C and C.UTF8 ? =C2=A0 Use "C". See this almost identical thread: https://www.postgresql.org/message-id/flat/PH0PR11MB51911905C6D8C753E98504F= CD6B59%40PH0PR11MB5191.namprd11.prod.outlook.com Yours, Laurenz Albe