Postgres Pro
Downloads
Home   >   mailing lists

Re: select (\'*\' ~* \'*\')=true while select (\'*\' ilike \'*\') - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: select (\'*\' ~* \'*\')=true while select (\'*\' ilike \'*\')
Date
Msg-id 4B98C80D020000250002FC74@gw.wicourts.gov
Whole thread Raw
In response to select (\'ã\' ~* \'Ã\')=true while select (\'ã\' ilike \'Ã\')  (desoft@freemail.gr)
List pgsql-admin
Tree view 
<desoft@freemail.gr> wrote:

> I have a freshly compiled installation of postresql on ubuntu
> 9.10.

What PostgreSQL version?  Compiled with what configuration options?

> encoding is set correctly.

To what?  With what character set, collation, etc.?

You've posted some of the information needed to understand the
problem, but please review this for ideas on what else might help
people identify the cause:

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

-Kevin

pgsql-admin by date:

Previous
From: desoft@freemail.gr
Date:
Subject: select (\'ã\' ~* \'Ã\')=true while select (\'ã\' ilike \'Ã\')
Next
From: Tom Lane
Date:
Subject: Re: select (\' \' ~* \' \')=true while select (\' \' ilike \' \')