Re: pg_trgm - Mailing list pgsql-hackers

From Andres Freund
Subject Re: pg_trgm
Date
Msg-id 201005271418.19452.andres@anarazel.de
Whole thread Raw
In response to Re: pg_trgm  (Tatsuo Ishii <ishii@postgresql.org>)
Responses Re: pg_trgm
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Synchronization levels in SR
Next
From: Fujii Masao
Date:
Subject: Re: Synchronization levels in SR