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

Re: garbage in psql -l

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, Peter Eisentraut <peter_e(at)gmx(dot)net>, Roger Leigh <rleigh(at)codelibre(dot)net>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: garbage in psql -l
Date: 2009-11-25 14:42:32
Message-ID: 9837222c0911250642o783c10a3p88808534409b2b7e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Wed, Nov 25, 2009 at 15:41, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Magnus Hagander <magnus(at)hagander(dot)net> writes:
>> FWIW, this patch also *completely* breaks the default windows
>> installs, which will have the database in UTF-8 but there is *never*
>> any UTF-8 support on the console (only UTF-16).
>
> Hmm ... so how do we work with utf-8 data in the database?  That
> should be the same case AFAICS.

It breaks, yes :-), and you have to set the client encoding manually.

But it works in the simple case where your data is ASCII for example.
Which usually means it's fine for listing databases, or database
objects, or such things. But with the unicode line patch, it's
basically completely useless, not just partially annoying.


-- 
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2009-11-25 15:04:03
Subject: Re: garbage in psql -l
Previous:From: Tom LaneDate: 2009-11-25 14:41:07
Subject: Re: garbage in psql -l

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