Re: BUG #2175: 22021: invalid byte sequence for encoding \"UNICODE\":

From: tomas(at)tuxteam(dot)de (Tomas Zerolo)
To: Roberto <speedrob(at)pop(dot)com(dot)br>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2175: 22021: invalid byte sequence for encoding \"UNICODE\":
Date: 2006-01-17 05:34:42
Message-ID: 20060117053442.GB9838@www.trapp.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Jan 16, 2006 at 11:55:12PM +0000, Roberto wrote:
>
> The following bug has been logged online:
>
> Bug reference: 2175
> Logged by: Roberto
> Email address: speedrob(at)pop(dot)com(dot)br
> PostgreSQL version: 8.0
> Operating system: windows XP
> Description: 22021: invalid byte sequence for encoding \"UNICODE\":
> Details:
>
> when I go to insert one string with accent in the bank of the following o
> error:
> 22021: invalid byte sequence for encoding \"UNICODE\":

This usually means that the encoding of your client is not UTF-8. Try
some query like "SET client_encoding TO 'LATIN1'" to see if the problem
disappears. Better yet -- try to convince the client to use UTF-8
encoding.

HTH
-- tomas

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Marcin 2006-01-17 13:07:12 Re: Huge number of disk writes after migration to 8.1
Previous Message Stephan Szabo 2006-01-17 02:46:50 Re: BUG #2172: Problem with query in order by