Thread: MultyByte Question

-----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)

Anyone knows about this?

thanks
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFA+kds6qRqJtQ5jpkRAkv+AJ9Oip7gSt7q5Pr3nz5mHepFnf5xBwCfaAGr
TLiQm2DnqelaYTbhHEuD0sw=
=JGOm
-----END PGP SIGNATURE-----

В Вск, 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>