Re: BUG #13440: unaccent does not remove all diacritics

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mike(at)busbud(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #13440: unaccent does not remove all diacritics
Date: 2015-06-14 17:59:18
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

mike(at)busbud(dot)com writes:
> Sorry, I couldn't install the most recent minor release, but I did try this
> on several different versions. I used Heroku to try a 9.4.3 build, and got
> the same results

> select '' as input, unaccent('') as observed, 't' as expected;
> input | observed | expected
> -------+----------+----------
> | | t
> (1 row)

Hm, I do see


in unaccent.rules, so the transformation ought to happen. I suspect
an encoding issue, eg your terminal window is not transmitting characters
in the encoding Postgres thinks you're using. You did not provide any
info about server encoding, client encoding, or client LC_xxx environment,
so it's hard to debug from here.

regards, tom lane

In response to


Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2015-06-14 22:41:09 Re: BUG #13441: pg_settings.pending_restart cann't reflect changed setting in configure file.
Previous Message bz 2015-06-14 15:59:12 BUG #13442: ISBN doesn't always roundtrip with text