Re: [BUGS] BUG #14794: Installation failure if user specify French password

On Fri, Sep 01, 2017 at 10:15:37AM +0000, vinod.t.v@outlook.com wrote:
> I have specified 
> Télécharger as the password during postgres installation in french OS.
> installation failed.

> ex‚cution de l'initialisation aprŠs bootstrap...FATAL:  sǸquence d'octets
> invalide pour l'encodage ¶® UTF8 ¶¯ : 0xe0 0x74 0x27

This is a character encoding mismatch.  Within an established database
session, PostgreSQL has robust encoding conversion.  During initdb and
connection establishment, encoding treatment is much more primitive.  This has
been on https://wiki.postgresql.org/wiki/Todo for years, and fixing it is low
priority.  I recommend using only ASCII in user names, passwords, and database
names.

If you still want this, set an ASCII password during installation, and then
change it with ALTER USER.  This will work well only if all your client
software sends the password in the same encoding as the database where you
issue ALTER USER (probably UTF8).


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs