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 1uN9BG-00Cu34-M4 for pgsql-general@arkaria.postgresql.org; Thu, 05 Jun 2025 11:54:46 +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 1uN9BE-008AX5-Nw for pgsql-general@arkaria.postgresql.org; Thu, 05 Jun 2025 11:54:45 +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 1uN9BE-008AWx-D2 for pgsql-general@lists.postgresql.org; Thu, 05 Jun 2025 11:54:45 +0000 Received: from mail-ot1-x331.google.com ([2607:f8b0:4864:20::331]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uN9BD-000M2D-11 for pgsql-general@postgresql.org; Thu, 05 Jun 2025 11:54:44 +0000 Received: by mail-ot1-x331.google.com with SMTP id 46e09a7af769-735a9e65471so507833a34.1 for ; Thu, 05 Jun 2025 04:54:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1749124479; x=1749729279; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=/kjjypWUoimoI+H4FEKt4edq18asQIaSFLmC0m+SWpI=; b=POLzZvCsLAktvpu6mtnrK/m1kf4Udn2owXowEIzbyN7p9d7tgEvPOXUqv8ZsAU2nBo YOp5zMxcmgkqaTTAKY/KhaD7aVtcE6yQWwsCDvRTYZUCgspkCGpJ4611Mu5KKu6Oajbl fWkOQIpgsfD1PICS1znzvKKJ7R2SFb6Ti4bCrOm4jmr4JMesjg+hkMRGlbguNCZFJCYq rBhU8MmWYV38CHiP3RVB6osAFB7kiuaZUsWDvBn9L7AgU/D0rhPMD/MsKscuH4XZjG9J gz5QxwR1hXvPGbVYjwk6lo4Ry2sGfU7+XlZ4JvNQrt9yd+ZgWP6B734HW5RzjEdyCZGh GmCQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1749124479; x=1749729279; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=/kjjypWUoimoI+H4FEKt4edq18asQIaSFLmC0m+SWpI=; b=BQxGRaijgxJfYs/NWWW1xt8zfv1cgtMV+h6vZvJ55sZjU74Jhr5i/8RtSkk43gVcnS Opny91Kx3MbHqN6O0dwUYXvhVGBCLJM0ImwLlHJHY3r0VA+OmlJWbH6WH42LfqtOclTf Dbd/QQzFlpAAy0FtZ5875KHZAk4mYgX76NHYlZxcuFlz8a+gyP+maWdY7qRgBbhpA2AS /oEsGvofHyTv5KtS6zcIhR7+8jb93IKiCXKuWZveoMKVmRM1hJfl3oBy06rjczLHYeW4 KcsQI4C7kSdUVxDlr695eE6HE0omuhxuZyKTwqNUeqiJAOfcOjR7vGbeL2ynwZ3RH3F3 PFLA== X-Gm-Message-State: AOJu0YwjtL6ikmUnP8IippxyXsmK1BpKrxGp1GU4x/SJ0Wmd7ceCzIEh 0PdcQGZnpEgRGkJLu+RBr9G/WqTlsNppKCKHUb/amTTRONhn8kiu7PuYjWKDQyN/E0WkesIejdI bv2LzIgO5wcYgyD8XNol2gzLBXN2tx0NxHw== X-Gm-Gg: ASbGnctOYRRSxQAo0U6onMMrIs1/ws9oL0CWagXMUUEMozDOL6P9VUfSf+p80CPKs82 hwt5ELMSQ2HXmfKo2RK5pJdd8I179tvRbHGTkAem4Ykf9zJE3OQbN9ZlfpyC8cda6jWR/LN1M8z eswxNJnvq9NdrppFC9820YpxJX5/XN9vqHgUo= X-Google-Smtp-Source: AGHT+IHKt9Ja8ZCR5828t30/4bTrVBHIM87hxi1AUV4CZrLSBxCpaO/itq37U1V/dcgKluRY3oDlnlztn6TBS02dpy4= X-Received: by 2002:a05:6870:c69c:b0:2c2:4090:9e8 with SMTP id 586e51a60fabf-2e9bf4cd522mr4088197fac.22.1749124478461; Thu, 05 Jun 2025 04:54:38 -0700 (PDT) MIME-Version: 1.0 References: <271a4c5ac6e568fe9ff250d9e0e70fb13a7eb103.camel@cybertec.at> In-Reply-To: <271a4c5ac6e568fe9ff250d9e0e70fb13a7eb103.camel@cybertec.at> From: Dominique Devienne Date: Thu, 5 Jun 2025 13:54:27 +0200 X-Gm-Features: AX0GCFskKNbezUktauo-70eM-7YLnG14iId_sIg8EN43hMn5SP9xc47VtK2LxaA Message-ID: Subject: Re: LOCALE C.UTF-8 on EDB Windows v17 server To: Laurenz Albe Cc: pgsql-general@postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Jun 5, 2025 at 1:40=E2=80=AFPM Laurenz Albe wrote: > On Thu, 2025-06-05 at 10:53 +0200, Dominique Devienne wrote: > > It clearly says "locale or builtin_locale", emphasis on the OR. > > You are right, and that's how it works on Linux. > BUILTIN_LOCALE is not required. Still, required or not, they yield different results (for datcollate and datctype), which is hardly expected.