Skip site navigation (1) Skip section navigation (2)

Re: UTF8MatchText

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>, Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-patches(at)postgresql(dot)org
Subject: Re: UTF8MatchText
Date: 2007-05-18 15:43:49
Message-ID: 464DC9B5.8050803@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches

Tom Lane wrote:
> ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> writes:
>   
>> Yes, I only used the 'disjoint representations for first-bytes and
>> not-first-bytes of MB characters' feature in UTF8. Other encodings
>> allows both [AB] and [BA] for MB character patterns. UTF8Match() does
>> not cope with those encodings; If we have '[AB][AB]' in a table and
>> search it with LIKE '%[BA]%', we judge that they are matched by mistake.
>>     
>
> AFAICS, the patch does *not* make that mistake because % will not
> advance over a fractional character.
>
> 	
>   

Unless I hear differently, my present intention is to apply the 
suggested improvement universally. I'll wait a day or two before 
completing the patch.

cheers

andrew

In response to

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2007-05-18 16:05:55
Subject: Signing off of patches (was Re: Not ready for 8.3)
Previous:From: Heikki LinnakangasDate: 2007-05-18 15:19:18
Subject: Re: Maintaining cluster order on insert

pgsql-patches by date

Next:From: Zoltan BoszormenyiDate: 2007-05-18 19:50:57
Subject: Standard compliant DEFAULT clause
Previous:From: Heikki LinnakangasDate: 2007-05-18 15:19:18
Subject: Re: Maintaining cluster order on insert

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group