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: [EMAIL PROTECTED] > 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
signature.asc
Description: Digital signature
