Re: MultyByte Question - Mailing list pgsql-novice

From Markus Bertheau
Subject Re: MultyByte Question
Date
Msg-id 1090147779.2741.4.camel@teetnang
Whole thread Raw
In response to MultyByte Question  (Alexis Serafin <listas@aserafin.com>)
List pgsql-novice
В Вск, 18.07.2004, в 11:48, Alexis Serafin пишет:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi, I?m a spanish user from a short time and I?ve a problem each time I
> tried to insert a record with a special character like á ó (letter with
> accent) which are supported under latin charset. The result is like:
>
> PostgreSQL Error: 1 (ERROR: invalid byte sequence for encoding
> "UNICODE": 0xfced6d )
>
> The server (postgresql v.7.4.2-4 Debian Sarge) is installed under
> UNICODE charset and the database is with this code (I?ve checked it with
> pgsql -l)
> The server machine runs under 8859-15 (european with euro symbol)

Set client_encoding appropriately:

http://www.postgresql.org/docs/current/static/runtime-config.html

Possible values are:

http://www.postgresql.org/docs/current/static/multibyte.html

--
Markus Bertheau <twanger@bluetwanger.de>


pgsql-novice by date:

Previous
From: Alexis Serafin
Date:
Subject: MultyByte Question
Next
From: Steve Tucknott
Date:
Subject: FUNCTION error and UNICODE