| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Alejandro Javier Pomeraniec <apomeraniec(at)buenosaires(dot)gov(dot)ar> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Accent insensitive search |
| Date: | 2003-07-01 19:42:16 |
| Message-ID: | 20030701194215.GC25995@dcc.uchile.cl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Jul 01, 2003 at 03:11:54PM +0000, Alejandro Javier Pomeraniec wrote:
> Hi ! Does anyone knows how to make accent insensitive searches??
Convert both the pattern and the column to ASCII with to_ascii
> SELECT * FROM testtable WHERE testfield like '%olo%';
SELECT * FROM testtable WHERE to_ascii(testfield) like '%olo%';
Do you know the pgsql-ayuda mailing list? You may like it.
http://tlali.iztacala.unam.mx/mailman/listinfo/pgsql-ayuda
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Pensar que el espectro que vemos es ilusorio no lo despoja de espanto,
sólo le suma el nuevo terror de la locura" (Perelandra, CSLewis)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2003-07-01 19:52:42 | New position and new location |
| Previous Message | Ian Barwick | 2003-07-01 19:39:08 | Re: Accent insensitive search |