var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Accent insensitive query
I'm making a PHP - postgresql (7.2) based application and I need to make an intelligent search box which accepts case-insensitive and accent-insenstive querys.
So far I have something like:
select * from detalle_pat where nombre ~* 'ELYSEES' order by rank, nombre
And because of ~ I have solved de case-insensitive query but in my data there is in the name: ELYSÉES (with accent on E) So this select statement
won't find anything.
I've tryed to look for this answer on postgresql.org but it seems that archives.postrgresql.org (where is suposed to be the answer ) wont work.
like and ilike
If you are trying to use case-insensitive with StRiNgs use: ilike.
If you want exact match of a StRiNg use: like
Hope that helps