Home > Archive > PostgreSQL Hacks > February 2006 > Re: character encoding in StartupMessage









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: character encoding in StartupMessage
Christopher Kings-Lynne

2006-02-28, 8:32 pm

> 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



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com