On Sat, Dec 07, 2002 at 07:06:45PM -0300, Pedro Igor wrote:
> Thanks, you know if some possible release would have some internal to deal
> with this ?
>
> Abraços
> Pedro Igor
> >
> > CREATE FUNCTION lower_ascii (text) RETURNS text AS '
> > BEGIN
> > RETURN lower(to_ascii($1));
> > END
> >
On Fri, Dec 06, 2002 at 09:33:10PM +0100, Cédric Dufour (public) wrote:
> Use the 'to_ascii' function to convert your string to the "no accent" ASCII
> equivalent before accomplishing your comparison
>
> SELECT foo FROM table WHERE ( to_ascii(foo) ILIKE to_ascii('caractères
> accentués') );
>
> T
er 06, 2002
14:31To: [EMAIL PROTECTED]Subject: [SQL]
Accent-insensitive
Does have PostgreSQL some option to allow me
execute selects accent-insensitive ?
I can´t find any reference, including the manual
Pedro Igor
Does have PostgreSQL some option to allow me
execute selects accent-insensitive ?
I can´t find any reference, including the manual
Pedro Igor
