Re: Question about encoding

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Daniel Serodio <dserodio(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Question about encoding
Date: 2006-11-28 04:27:44
Message-ID: 523023.44829.qm@web31815.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Is it possible to configure PostgreSQL so that a " LIKE 'a' " query
> will match a 'á' value, ie, make it accent-insensitive ?

I forgot this was possible using regular expressions. I don't think it is possible using the LIKE
syntax. if you use something like:

select * from yourtable
where yourstring ~ '[=e=]';

http://www.postgresql.org/docs/8.2/interactive/functions-matching.html#POSIX-BRACKET-EXPRESSIONS

Regards,

Richard Broersma Jr.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2006-11-28 04:28:07 Re: NULLs ;-)
Previous Message wombat 2006-11-28 03:10:53 are wombats good?