Re: [BUGS] PostgreSQL 8.3.7: soundex function returns UTF-16 characters

Tom Lane wrote: Frans writes: Tom Lane wrote: The fuzzystrmatch module doesn't really work with utf8 (nor any other multibyte encoding), because it depends on the functions. What you'll probably get when applying it to non-ascii utf8 is an invalidly encoded string.

Re: [BUGS] PostgreSQL 8.3.7: soundex function returns UTF-16 characters

Tom Lane wrote: Frans writes: We have just discovered a problem with the soundex function in PostgreSQL 8.3.7. The problem is easy to reproduce. The following query returns the ASCII code of the soundex representation of the Greek letter Pi: select ascii (soundex(&#

[BUGS] PostgreSQL 8.3.7: soundex function returns UTF-16 characters

n index on such a column or doing VACUUM FULL on the table results in errors like: ERROR: could not convert string to UTF-16 Regards, Frans -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs