Postgres Pro
Downloads
Home   >   mailing lists

Re: Like with special character - Mailing list pgsql-sql

From Emi Lu
Subject Re: Like with special character
Date
Msg-id 44BD25C0.7050604@encs.concordia.ca
Whole thread Raw
In response to Re: Like with special character  (Oleg Bartunov <oleg@sai.msu.su>)
Responses Re: Like with special character
List pgsql-sql
Tree view 
>
>
>> 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

Some comments about it.

pgsql-sql by date:

Previous
From: "Tony Wasson"
Date:
Subject: Re: How to pass array of values to a stored procedure
Next
From: "Aaron Bono"
Date:
Subject: Re: hi let me know the solution to this question