Re: [GENERAL] 0xc3 error Text Search Windows French

2008-06-26 Thread Alvaro Herrera
Andrew wrote: > Thanks Alvaro. Please don't forget to CC the list. > Reading the source for the patch, I can see how that should address the > issue. Though I don't really understand how it is working in Linux but > not on Windows. I assume that Linux OS is passing the UTF-8 character > a

Re: [GENERAL] 0xc3 error Text Search Windows French

2008-06-25 Thread Alvaro Herrera
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('fr

Re: [GENERAL] 0xc3 error Text Search Windows French

2008-06-25 Thread Andrew
One additional aspect. I just ran the create text search dictionary command without the stopfile declaration using the OO dictionaries, and it worked fine with the select ts_lexize('public.fr_ispell', 'catalogue'); command executing with no problems. However, after creating an associated cata

Re: [GENERAL] 0xc3 error Text Search Windows French

2008-06-25 Thread Andrew
Sorry one last detail. All of my databases are in utf-8 format. My Windows XP is en_AU and defaults to ISO-8859-1 character sets. My postgresql.conf is set to the default for the client_encoding setting, which should then default to the database utf-8 format. Andrew wrote: One additional a

[GENERAL] 0xc3 error Text Search Windows French

2008-06-25 Thread Andrew
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'); gett