Horton
Menu

Re: pg_trgm

Andres Freund <andres@anarazel.de>

View thread
From: Andres Freund <andres@anarazel.de>
To: pgsql-hackers@postgresql.org
Cc: Tatsuo Ishii <ishii@postgresql.org>, teodor@sigaev.ru
Date: 2010-05-27T12:18:17Z
Lists: 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}
 (1 row)
 
Time: 0.443 ms
test=# select similarity('日本語', '日本後');
  similarity 
 ------------
    0.333333
 (1 row)
 
Time: 0.426 ms


Encoding is UTF-8...

Andres