Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iQFYe-0003X3-Uh for pgsql-admin@arkaria.postgresql.org; Thu, 31 Oct 2019 18:52:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iQFYd-0005xi-Lu for pgsql-admin@arkaria.postgresql.org; Thu, 31 Oct 2019 18:52:31 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iQFYd-0005wn-5z for pgsql-admin@lists.postgresql.org; Thu, 31 Oct 2019 18:52:31 +0000 Received: from mail-wr1-x442.google.com ([2a00:1450:4864:20::442]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1iQFYa-0006OR-FQ for pgsql-admin@postgresql.org; Thu, 31 Oct 2019 18:52:29 +0000 Received: by mail-wr1-x442.google.com with SMTP id b3so1643406wrs.13 for ; Thu, 31 Oct 2019 11:52:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=nZ+7ZxuYiq0oH8LagZZzGj8jXsM/qKaJXgfDDBqXNns=; b=SOjPhakXt8uPmAiVgbF4iFPcS5Zd7PzhslEPrXzidkK8nD/XQOjyzyTl5mwvQLSsSY 9dgcog2Cp21dx/7xm6p2PAOakduaKSW8UEX72NzG7EEMaSfF8bCufXJvw1UZ6y4M8WDr 9sM99hVp/z84kCJUHQ0nP/mTBhy7b5nIrvxLez6IwK54eoIqePmfCbPwt4tUCLSfALBE +j2wy3EGyB7F71bB9jdmwudnsUVNlx0QZjMK382n8Wyh1PCUbjwx+YK3tMlvYFWHD1CS 8hOqtyRShbUEKg88ylGl2WWKA6GYePDnlWejuiG46xwdD12yaxHiHFxxa/ABlaM1fuqa obTQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=nZ+7ZxuYiq0oH8LagZZzGj8jXsM/qKaJXgfDDBqXNns=; b=QxnuZ4EQlt5B87wh/KfYkfKUjeBPtKMJS/7SH6wiQqMNfef1n0hUTvrcgoooY4BhTj /t0KmeCM8dORqSQu3PFHIhqCWBNX7bgxPvWZUERTz2rMYNMN1IOU6ADz64gfi4duETxf eUpHuZcrmCC4BJiwE8erY0EUKs2+QR2guKq8yXizVPDGsgon14N1oVT8LJbc0KfOcuFC IlrYSiB35Z8i//hhY+l2gP9dd2aZW9PqLCj6ujCZWN5o9/4ziQ2c/GDI18NSvOrZVnxL VPh7cwsuhIhz9dymqr6kGJiQG7UsM9b+wgKiGvGjfnMRdulQdgjcDRz/FrvVpn2+UP7u NTRA== X-Gm-Message-State: APjAAAVY04oQTf/mNEOPgiiEBDPbLYn015QSdP9rSyt374UA8S/vcyH6 cqL3tQw3ZGxbjO5flAbqyJgeew== X-Google-Smtp-Source: APXvYqzg5q/UUOptpHzdBYjvHfXNffD3qV52Bv6P6uvCqvi4Ng3wR1oylkd7TwqXvNgI3OaGIpqyRw== X-Received: by 2002:adf:a497:: with SMTP id g23mr6783066wrb.135.1572547946843; Thu, 31 Oct 2019 11:52:26 -0700 (PDT) Received: from localhost.localdomain ([213.208.157.36]) by smtp.gmail.com with ESMTPSA id t1sm2302909wmj.34.2019.10.31.11.52.25 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 31 Oct 2019 11:52:26 -0700 (PDT) Message-ID: Subject: Re: In AIX server encoding utf8 is not supported From: Laurenz Albe To: mallikarjun t , pgsql-admin , Peter Eisentraut , Luca Ferrari Date: Thu, 31 Oct 2019 19:52:24 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.32.4 (3.32.4-1.fc30) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk mallikarjun t wrote: > I am initializing data directory by using following command, > > ./initdb -D -W > > It is taking client_encoding LATINA1, but I want to change UTF8, > > how to change, I already tried it is not supported, > > Kindly help me, I am also attaching the screenshot also, Please no screenshots, text is better. You need to use a locale like "en_US.utf8" (or whatever the name on AIX is) that works with UTF8. If you cannot find such a locale with "locale -a", you'll have to install it from the AIX installation sources. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com