Re: 0xc3 error Text Search Windows French

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Andrew <archa(at)pacific(dot)net(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 0xc3 error Text Search Windows French
Date: 2008-06-25 19:35:12
Message-ID: 20080625193512.GF17573@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andrew wrote:
> I have a feeling that an issue I'm running into is related to this:
> http://archives.postgresql.org/pgsql-bugs/2008-06/msg00113.php
>
> On Windows XP running PgAdmin III 1.8.4 against either PostgreSQL 8.3.0
> or 8.3.3 DB, when attempting to do a:
>
> select * from ts_debug('french', 'catalogue');
>
> getting the following error:
>
> ERROR: invalid byte sequence for encoding "UTF8": 0xc3

This is probably a bug fixed after 8.3.3:

http://git.postgresql.org/?p=postgresql.git;a=commitdiff;h=6bcf5a85233f7a039648990d1037119efb61146d
(This is the HEAD version of the patch; 8.3 should be identically
patched.)

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma 2008-06-25 23:08:46 IF ROW( NEW ) <> ROW( OLD )
Previous Message Howard Cole 2008-06-25 19:27:57 POSIX Escape