Emi Lu <[EMAIL PROTECTED]> escreveu: 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 youI got the following error:select to_ascii('ê');ERROR: encoding conversion f
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
I got the following error:
select to_ascii('ê');
ERROR: encoding conversion from UNICODE to ASCII not supported
Perfect, thanks
I found regex for postgreSql too, it's interesting too
select * from divers
where s_libelle ~* '^t(e|é|ê)'
Oleg Bartunov a écrit :
> On Mon, 1 May 2006, tnodev wrote:
>
>> Hello,
>>
>> I'm using postGre with tables which contain French character
>> (?...). Is there a foncti
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)--
Hi,
tnodev a écrit :
> I'm using postGre with tables which contain French character (éèçàù...).
> Is there a fonction which performs a like in replacing é (e cute) by e ?
>
select translate('forêt', 'àâäéèêëîïôöùûü', 'aaaiioouuu');
Change the first word (forêt) by the string you want charac
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 ?
thanks...
---(end of broadcast)---
TIP 6: explain analyze is your friend