Skip site navigation (1) Skip section navigation (2)

Re: BUG #2400: 'Ã

From: tomas(at)tuxteam(dot)de (Tomas Zerolo)
To: Yusuf Siddiqui <ysiddiqui(at)i3(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2400: 'Ã
Date: 2006-04-20 04:40:58
Message-ID: 20060420044058.GA26913@www.trapp.net (view raw or flat)
Thread:
Lists: pgsql-bugs
On Tue, Apr 18, 2006 at 11:34:53PM +0000, Yusuf Siddiqui wrote:
> 
> The following bug has been logged online:
> 
> Bug reference:      2400
> Logged by:          Yusuf Siddiqui
> Email address:      ysiddiqui(at)i3(dot)com
> PostgreSQL version: 8.1
> Operating system:   Linux
> Description:        'Æ' considered invalid UTF-8 character
> Details: 
> 
> The character 'Æ' is rejected as an invalid UTF-8 character.

Well, maybe it is :-)

> Here are the steps used to recreate it:
> 
> create table test (text_field text);
> insert into test (text_field) values ('Æ');
> 
> Returned error: 
> invalid UTF-8 byte sequence detected near byte 0x92

[...]

I'd need to know more. I gather from your mail that you are entering the
character into psql from a console. Several factors are relevant here:

  - which character encoding does your console have?
    (if it is, e.g. iso-8859-x then this will be probably the culprit)
  - which client encoding is set? (in psql type SHOW CLIENT_ENCODING;)
  - which encoding is the server using (I'd guess utf-8; it doesn't need
    to be the same as the client's, since it will try to convert).

HTH
-- tomás

In response to

pgsql-bugs by date

Next:From: andrea suisaniDate: 2006-04-20 07:36:12
Subject: Re: pg_dump or hardware?
Previous:From: Theo SchlossnagleDate: 2006-04-20 03:33:11
Subject: Re: BUG #2401: spinlocks not available on amd64

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group