Re: MultyByte Question

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: Alexis Serafin <listas(at)aserafin(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: MultyByte Question
Date: 2004-07-18 10:49:39
Message-ID: 1090147779.2741.4.camel@teetnang
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)bluetwanger(dot)de>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Steve Tucknott 2004-07-18 11:00:39 FUNCTION error and UNICODE
Previous Message Alexis Serafin 2004-07-18 09:48:31 MultyByte Question