Thread: codepage setting, \encoding

codepage setting, \encoding

From
perico@12move.nl
Date:
Hi,

 I'm using postgres 8.0 and I'm collecting data from many countries. So I've
some slovakian data and i can't get properly into my table (COPY command).
I've tried many codepage settings but none of those seem to support the special
characters. Does someone know which codepage I shoud use?


cheers,

Peter

_____________________________________________________________________

12move ADSL vanaf 18,95 euro! GRATIS modem, GEEN aansluitkosten en GEEN datalimiet!
Ga nu naar http://adsl.12move.nl




Re: codepage setting, \encoding

From
Martijn van Oosterhout
Date:
On Tue, Feb 01, 2005 at 10:20:55PM +0100, perico@12move.nl wrote:
> Hi,
>
>  I'm using postgres 8.0 and I'm collecting data from many countries. So I've
> some slovakian data and i can't get properly into my table (COPY command).
> I've tried many codepage settings but none of those seem to support the special
> characters. Does someone know which codepage I shoud use?

Does your database encoding support slovakian characters? (ie, is it
unicode). If so, "set client_encoding=xxx" should work for you.

Can you past an example that's failung?
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Attachment

Betr: Re: codepage setting, \encoding

From
perico@12move.nl
Date:
I'm using ISO-8859-5 so should I change this to unicode?


>-- Oorspronkelijk bericht --
>Date: Tue, 1 Feb 2005 22:35:11 +0100
>From: Martijn van Oosterhout <kleptog@svana.org>
>To: perico@12move.nl
>Cc: pgsql-general@postgresql.org
>Subject: Re: [GENERAL] codepage setting,  \encoding
>Reply-To: Martijn van Oosterhout <kleptog@svana.org>
>
>
>On Tue, Feb 01, 2005 at 10:20:55PM +0100, perico@12move.nl wrote:
>> Hi,
>>
>>  I'm using postgres 8.0 and I'm collecting data from many countries. So
>I've
>> some slovakian data and i can't get properly into my table (COPY command).
>> I've tried many codepage settings but none of those seem to support the
>special
>> characters. Does someone know which codepage I shoud use?
>
>Does your database encoding support slovakian characters? (ie, is it
>unicode). If so, "set client_encoding=xxx" should work for you.
>
>Can you past an example that's failung?
>--
>Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
>> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is
a
>> tool for doing 5% of the work and then sitting around waiting for someone
>> else to do the other 95% so you can sue them.
>
>Bijlage: Bijlage
>


_____________________________________________________________________

12move ADSL vanaf 18,95 euro! GRATIS modem, GEEN aansluitkosten en GEEN datalimiet!
Ga nu naar http://adsl.12move.nl