Re: pg_trgm

On Thursday 27 May 2010 14:40:41 Tatsuo Ishii wrote:
> > > 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...
> 
> What is your locale?
It was en_EN.UTF-8. Interesting. With C it fails...

Andres