Re: character encoding in StartupMessage

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: John DeSoi <desoi(at)pgedit(dot)com>
Cc: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: character encoding in StartupMessage
Date: 2006-02-28 05:18:44
Message-ID: 4403DD34.8020709@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> I could not find anything in the Frontend/Backend protocol docs about
> character encoding in the StartupMessage. Assuming it is legal for a
> database or user name to have unicode characters, how is this handled
> when nothing yet has been said about the client encoding?

A similar badness is that if you issue CREATE DATABASE from a UTF8
database, the dbname will be stored as UTF8. Then, if you go to a
LATIN1 database and create another it will be stored as LATIN1.

Then, it's impossible to display both database names on the same screen
or webpage as they have different encodings... Not only that but it's
impossible to know what encoding it IS in since it's the encoding of the
database from where you issued the CREATE DATABASE instruction from, not
the encoding of the database itself.

Chris

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Suvarna 2006-02-28 05:35:16 bug in 7.3.2
Previous Message John DeSoi 2006-02-28 05:05:44 character encoding in StartupMessage