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 1wJeBc-000671-1B for pgsql-general@arkaria.postgresql.org; Sun, 03 May 2026 21:17:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wJeBa-004kNn-3D for pgsql-general@arkaria.postgresql.org; Sun, 03 May 2026 21:17:11 +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 1wJeBa-004kNe-25 for pgsql-general@lists.postgresql.org; Sun, 03 May 2026 21:17:10 +0000 Received: from mail-wm1-x32d.google.com ([2a00:1450:4864:20::32d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wJeBX-000000002NA-3ghJ for pgsql-general@lists.postgresql.org; Sun, 03 May 2026 21:17:09 +0000 Received: by mail-wm1-x32d.google.com with SMTP id 5b1f17b1804b1-483487335c2so35744325e9.2 for ; Sun, 03 May 2026 14:17:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1777843025; x=1778447825; darn=lists.postgresql.org; 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=HqQlVTND8skYqJWEWPLP22xu0Ygk4HPrBMR2R6m2xks=; b=UoGu2NLolNm74Y5ujgSVQJrqJ/cVRlFjc7+gpvMTLZG1kpyy6h7D/rCyQCMrYDjRfq jeDkFDSn8CGVVsdql3j0X2vUTfm8wcScuYA/s4azHis5ixSpulgZWvl63ByiRQ4FtV/w tH+tFIzWFb5VSwWakq+15EJObAd+NEcRQ7EqoAH4B59e9wultHEz0vQ4QSNOO9IUKx6h IgZNb9nX9w0KQBC1zlnSVhmMnkTTj9FuLctaqQNs3tZbLAw01frZLv4PsHGlW3VHwZh7 JjdK6CxSB4E6S3mdS3yuROrdORxlnxyTG0LVNalEQA5NKIIyh8LRdhbqBXgXJdFQQlxC YTsg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1777843025; x=1778447825; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=HqQlVTND8skYqJWEWPLP22xu0Ygk4HPrBMR2R6m2xks=; b=g/Vro/Oqss7GIJ1Lwqgk71FzeiRbW7+0AB0ca2YbbTCjm0TRqYPiaSxLiDKZXjNkM/ O/7z9LqbolGKevgUZUQ6yo2pE6J12N/+e/u4JRC7WOiAQQd11lxbHRSBVQHFJfVq6C00 1kYmx4p5HAkywJ2psnJIwknVZjA5yeFHqM6wKY8LS+RJDueuG7SPRxy6obvDVlUom7es 7JrNeAY/6BMW5G7QFc9B/xxE03LUfcYceZqmLjDm0jDQxpCl26RHzJAETVl+hD31rH+n AOTP0PYl2/ZqyNRuQFqk3rL0nT4MC6a4wPttcKiAcoZ0wwUInSw2+IpCsLj04lXAzx7D ESiw== X-Forwarded-Encrypted: i=1; AFNElJ/Af5Cv5LGiF2dVsbzXm2p7DOF++Hx/fY2Pcei/0S9wT6AJBkbWJqhqHGaGTAEBmZqV5l3nmG729U22Stst@lists.postgresql.org X-Gm-Message-State: AOJu0Yyn/0mgEto1xdKrx6uP6FB2ynyKJ0dHbEREMq8750S/cW5uacMC 4xmHdiz/QWWgPeYTBrDWguZHa4yZi/Sv9NiJ/PLqFxWJ0R08B0JXAILokIwmjaTYe9j5ynvTxiF nDvb60oE= X-Gm-Gg: AeBDietc8q71bVDFhV4Oaq9nz10REpRLBDGI3Z5ASWVXC63/qla9hu6oH6RTr+dEvmG lLuin3qyhK0fSBCOguxWrXlKeIerTIp+NOt4Z7eitBmGH4GQkTJmVUh/EDIFiFOmnkcwSmJVymH 1BFMoUcBBi6Z3Cqq8kpa6shDKWvGWyM+y8X7lQhLGFOVHWqfQxJi2KetSOugDAYqU8/Q89VXWr0 ZGM+pz/RUYtna//+zqK+NTtrtKdoaZXJ/+SrY8NPn5aiocoHZrRv92hlVvacHmxgqrqD/xBBMtS cfhv4BE4OpRLCjGmxA0cCcId/ogrwsZBDCWzI5ZU7d2T4kTi8VeZYc7EHRCfjalUN6JK6WN76mB S6ppkWDwHzRpy26E8CVjHJaQh4bhs4voYc2x3y+qCRCadmg3/tsNb/hWs4twwHSLzqEwPuP5f53 g4qYCb3Htv/Umb450RJ496AzlXjs4hpTEjmx1vBcoLg9/zLkhPUkTN/Rb0Kn8oMxhJ X-Received: by 2002:a05:600c:6388:b0:488:b239:77ec with SMTP id 5b1f17b1804b1-48a98895044mr101995785e9.17.1777843025512; Sun, 03 May 2026 14:17:05 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:260:1d19:4c7b:8aed:5d60:9bd9]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-48a8eb69698sm397409885e9.1.2026.05.03.14.17.05 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 03 May 2026 14:17:05 -0700 (PDT) Message-ID: <63e4b5165442ada9f187a0e14bbfe04795088bcd.camel@cybertec.at> Subject: Re: Choosing default collation/ctype From: Laurenz Albe To: Ron Johnson , "pgsql-generallists.postgresql.org" Date: Sun, 03 May 2026 23:17:04 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.58.3 (3.58.3-1.fc43) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sun, 2026-05-03 at 17:05 -0400, Ron Johnson wrote: > > Just trying to create a generic tool to use for people everywhere... >=20 > Then choose UTF8. Right! And I recommend "C" for the collation. (The user can override the default in column definitions where necessary.) Yours, Laurenz Albe