Re: Catastrophic changes to PostgreSQL 8.4 - Mailing list pgsql-general

From Daniel Verite
Subject Re: Catastrophic changes to PostgreSQL 8.4
Date
Msg-id 939023cf-6ef5-4bfd-909f-7dc7fc235bbc@mm
Whole thread Raw
In response to Re: Catastrophic changes to PostgreSQL 8.4  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
    Craig Ringer wrote:

> While true in theory, in practice it's pretty unusual to have filenames
> encoded with an encoding other than the system LC_CTYPE on a modern
> UNIX/Linux/BSD machine.

It depends. In western Europe, where iso-8859-1[5] and utf8 are evenly used,
it's not unusual at all. You just have to extract an archive created by
someone who uses a different encoding than you. Since tar files don't carry
any information about the encoding of the filenames it contains, they come
out as they are, whatever LC_CTYPE is. The same problem exists for zip files.

Best regards,
--
Daniel
PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org

pgsql-general by date:

Previous
From: Avi Rozen
Date:
Subject: Re: [Bacula-users] Catastrophic changes to PostgreSQL 8.4
Next
From: "Kern Sibbald"
Date:
Subject: Re: [Bacula-users] Catastrophic changes to PostgreSQL 8.4