Re: MultyByte Question

В Вск, 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(at)bluetwanger(dot)de>