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: (view raw, whole thread or download thread mbox)
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

In response to


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-2017 The PostgreSQL Global Development Group