Re: pg_trgm

Hi,

On Thursday 27 May 2010 13:53:37 Tatsuo Ishii wrote:
> > It's already multibyte safe since 8.4
>
> No, it doesn't.
> Encoding is EUC_JP, locale is C. Included is the script to reproduce
> the problem.
test=# select show_trgm('日本語');               show_trgm               ---------------------------------------
{0x8194c0,0x836e53,0x1dc363,0x1e22e9}(1row) 
Time: 0.443 ms
test=# select similarity('日本語', '日本後'); similarity ------------   0.333333(1 row)
Time: 0.426 ms


Encoding is UTF-8...

Andres