Re: UTF8 problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
Cc: Daniel Verite <daniel(at)manitou-mail(dot)org>, Douglas McNaught <doug(at)mcnaught(dot)org>, Tino Wildenhain <tino(at)wildenhain(dot)de>, Alban Hertroys <alban(at)magproductions(dot)nl>, pgsql-general(at)postgresql(dot)org
Subject: Re: UTF8 problem
Date: 2006-06-08 21:50:59
Message-ID: 2004.1149803459@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Matthew T. O'Connor" <matthew(at)zeut(dot)net> writes:
> They have talked about changing the messageblks to binary instead of
> text. They said that one of their main objections is that bytea data is
> not compressed. I'm not sure that's true, but I don't see anything in
> the docs about it. I think they would move to bytea if it does compress.

These people really don't know what they're talking about, do they?

bytea goes through exactly the same compression logic as text. But
really it sounds to me like the easiest solution is just to run the
database in SQL_ASCII encoding.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hugo 2006-06-08 21:51:28 Re: psql command and file size
Previous Message Hugo 2006-06-08 21:48:16 psql command and file size