Thread: BUG #4336: Strange behaviour for to_ascii

The following bug has been logged online:

Bug reference:      4336
Logged by:          Maxime Carbonneau
Email address:      manitou@maikan.com
PostgreSQL version: 8.3.3
Operating system:   Mac OS X 10.5.4
Description:        Strange behaviour for to_ascii
Details:

With PostgreSQL 8.2.5, I used to_ascii to remove accents:
SELECT TO_ASCII(CONVERT('école' USING utf8_to_iso_8859_15), 'latin9');
=> ecole
With PostgreSQL 8.3.3, I had to made some changes since convert using is
gone. I'm using: SELECT
to_ascii(encode(convert_to('école','LATIN9'),'escape'),'LATIN9');
but the result is
=> \351cole

How can I remove accent letter with PostgreSQL 8.3.3?

SGVsbG8KCml0J3MgYnVnLAoKZm9yIHRoaXMgbW9tZW50LCBwbGVhc2UsIHRy
eToKCgpDUkVBVEUgRlVOQ1RJT04gdG9fYXNjaWkoYnl0ZWEsIG5hbWUpClJF
VFVSTlMgdGV4dCBBUyAndG9fYXNjaWlfZW5jbmFtZScgTEFOR1VBR0UgaW50
ZXJuYWw7Cgpwb3N0Z3Jlcz0jIENSRUFURSBGVU5DVElPTiB0b19hc2NpaShi
eXRlYSwgbmFtZSkKcG9zdGdyZXMtIyBSRVRVUk5TIHRleHQgQVMgJ3RvX2Fz
Y2lpX2VuY25hbWUnIExBTkdVQUdFIGludGVybmFsOwpDUkVBVEUgRlVOQ1RJ
T04KcG9zdGdyZXM9Iwpwb3N0Z3Jlcz0jIFNFTEVDVCB0b19hc2NpaShjb252
ZXJ0X3RvKCdQxZnDrWxpxaEgxb5sdXTDvSBrxa/FiCcsICdsYXRpbjInKSwn
bGF0aW4yJyk7CiAgICAgdG9fYXNjaWkKLS0tLS0tLS0tLS0tLS0tLS0tCiBQ
cmlsaXMgemx1dHkga3VuCigxIHJvdykKCgpwb3N0Z3Jlcz0jIFNFTEVDVAp0
b19hc2NpaShjb252ZXJ0X3RvKCfDqWNvbGUnLCdMQVRJTjknKSwnTEFUSU45
Jyk7CiB0b19hc2NpaQotLS0tLS0tLS0tCiBlY29sZQooMSByb3cpCgpSZWdh
cmRzClBhdmVsIFN0ZWh1bGUKCjIwMDgvNy8zMCBNYXhpbWUgQ2FyYm9ubmVh
dSA8bWFuaXRvdUBtYWlrYW4uY29tPjoKPgo+IFRoZSBmb2xsb3dpbmcgYnVn
IGhhcyBiZWVuIGxvZ2dlZCBvbmxpbmU6Cj4KPiBCdWcgcmVmZXJlbmNlOiAg
ICAgIDQzMzYKPiBMb2dnZWQgYnk6ICAgICAgICAgIE1heGltZSBDYXJib25u
ZWF1Cj4gRW1haWwgYWRkcmVzczogICAgICBtYW5pdG91QG1haWthbi5jb20K
PiBQb3N0Z3JlU1FMIHZlcnNpb246IDguMy4zCj4gT3BlcmF0aW5nIHN5c3Rl
bTogICBNYWMgT1MgWCAxMC41LjQKPiBEZXNjcmlwdGlvbjogICAgICAgIFN0
cmFuZ2UgYmVoYXZpb3VyIGZvciB0b19hc2NpaQo+IERldGFpbHM6Cj4KPiBX
aXRoIFBvc3RncmVTUUwgOC4yLjUsIEkgdXNlZCB0b19hc2NpaSB0byByZW1v
dmUgYWNjZW50czoKPiBTRUxFQ1QgVE9fQVNDSUkoQ09OVkVSVCgnw6ljb2xl
JyBVU0lORyB1dGY4X3RvX2lzb184ODU5XzE1KSwgJ2xhdGluOScpOwo+ID0+
IGVjb2xlCj4gV2l0aCBQb3N0Z3JlU1FMIDguMy4zLCBJIGhhZCB0byBtYWRl
IHNvbWUgY2hhbmdlcyBzaW5jZSBjb252ZXJ0IHVzaW5nIGlzCj4gZ29uZS4g
SSdtIHVzaW5nOiBTRUxFQ1QKPiB0b19hc2NpaShlbmNvZGUoY29udmVydF90
bygnw6ljb2xlJywnTEFUSU45JyksJ2VzY2FwZScpLCdMQVRJTjknKTsKPiBi
dXQgdGhlIHJlc3VsdCBpcwo+ID0+IFwzNTFjb2xlCj4KPiBIb3cgY2FuIEkg
cmVtb3ZlIGFjY2VudCBsZXR0ZXIgd2l0aCBQb3N0Z3JlU1FMIDguMy4zPwo+
Cj4gLS0KPiBTZW50IHZpYSBwZ3NxbC1idWdzIG1haWxpbmcgbGlzdCAocGdz
cWwtYnVnc0Bwb3N0Z3Jlc3FsLm9yZykKPiBUbyBtYWtlIGNoYW5nZXMgdG8g
eW91ciBzdWJzY3JpcHRpb246Cj4gaHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9y
Zy9tYWlscHJlZi9wZ3NxbC1idWdzCj4K