Skip site navigation (1) Skip section navigation (2)

Re: Database->ServerEncoding, ClientEncoding

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <jm(dot)poure(at)freesurf(dot)fr>
Cc: <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Database->ServerEncoding, ClientEncoding
Date: 2002-02-25 20:26:28
Message-ID: 1083.193.237.19.179.1014668788.squirrel@ssl.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-hackers
Jean-Michel POURE allegedly said:
> Hi Dave,
>
> I used pgSchema today with a Latin1 encoding hack.
>
> Whenever a character does not exist in Latin1 (example : euro sign), an
> error  is returned. Obviously, this is not always the case: Japanese is
> transformed  in unreadable characters without error.
>
> My impression is that client encoding is not ***very** secure. A full
> unicode  chain is a better solution. But we need Client encoding
> support as it offers  a wide variety of encodings ... and is compatible
> with VB.
>
> Maybe we could start modifying pgSchema->Databases and
> pgSchema->pgDatabase.  What would you think if we :
> - renamed EncodingName into ServerEncoding,
> - added ClientEncoding.

We currently have:

Encoding (Long)
EncodingName (String)

Maybe change these to:

ServerEncodingID (Long)
ServerEncodingName (String)

and add:

ClientEncodingID (Long)
ClientEncodingName (String)

The ClientEncodingID would be the Windows LCID (I assume that's relevant
in this case)

>
> Then, in frmSQLInput, we would add a combo to choose the encoding
> needed.

I'm not sure that's the best place. It would need to be somewhere that's
relevant to the whole connection, because that's how it would be set.

What about setting it from the Context menu (right click), and the
database properties page. We could then remember the encoding per database
in the registry for future connections.

> This will allow me to view UTF-8 data in Latin1 and export it in UTF-8.
> Isn't  it marvelous?

It will be when it works :-)

Regards, Dave.



In response to

Responses

pgadmin-hackers by date

Next:From: Dave PageDate: 2002-02-25 20:30:28
Subject: Re: Database->ServerEncoding, ClientEncoding (again)
Previous:From: Dave PageDate: 2002-02-25 20:14:08
Subject: Re: pgAdmin2 Japanese display

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group