Re: Like with special character

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: tnodev <tnodev(at)free(dot)fr>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Like with special character
Date: 2006-05-01 12:55:46
Message-ID: Pine.GSO.4.63.0605011655300.3992@ra.sai.msu.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, 1 May 2006, tnodev wrote:

> Hello,
>
> I'm using postGre with tables which contain French character (?????...). Is
> there a fonction which performs a like in replacing ? (e cute) by e ?

to_ascii() should helps you

>
> thanks...
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru)
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message TNO 2006-05-01 14:35:39 Re: Like with special character
Previous Message mlartz@gmail.com 2006-05-01 11:45:11 Re: join on a like