Re: Like with special character

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To:
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Like with special character
Date: 2006-07-18 18:17:36
Message-ID: 44BD25C0.7050604@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


>
>
>> 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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Aaron Bono 2006-07-18 18:35:31 Re: hi let me know the solution to this question
Previous Message Tony Wasson 2006-07-18 17:33:58 Re: How to pass array of values to a stored procedure