Postgres Pro
Downloads
Home   >   mailing lists

Translate function and strange results ... - Mailing list pgsql-general

From Hervé Piedvache
Subject Translate function and strange results ...
Date
Msg-id 200911011656.15359.bill.footcow@gmail.com
Whole thread Raw
Responses Re: Translate function and strange results ...
List pgsql-general
Tree view 
Hi,

Can someone can explain me why it's run like this with PostgreSQL v8.3.8 ?

base=# select translate('Hervé', 'é', 'e');
 translate
-----------
 Herve
(1 row)

base=# select translate('Hervé', 'âàäéèêëïöôùüû', 'aaaeeeeioouuu');
 translate
-----------
 Hervai
(1 row)

base=# \encoding
SQL_ASCII

Thanks,
--
Hervé Piedvache

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: sudoku in an sql statement
Next
From: David Fetter
Date:
Subject: Re: Windowing functions - future plans