donoteatcarrot wrote:

>Hello, Mr David Schnepper.
>
>I found a message posted on Wed Aug 27, 2003
>(though a little old ^^;).
>The message discussed about CollationKit.
>
>and you mentioned:
>
>
>>Agreed. That's the purpose of the special entry in the collation
>>driver interface -- which is used to support starting_with
>>and "like 'abc%'". It gives a "partial key" for the string,
>>using primary collation only - so that the partial key can be
>>used for a range search against the index.
>>
>>
>
>What dose "special entry" mean ?
>I made a "EN_UK_NOCASE" collation by following the instruction of the
>CollationKit.
>And also tested the following statement successfully:
>[select * from TABLENAME where FIELDNAME='A';]
>It returned the result 'A' and 'a'.
>But for
>[select * from TABLENAME where FIELDNAME like '%A%';]
>Only returned 'A'.
>
>How could I make a collation that works good with "like" ?
>
>

For 1.5.X, see http://sourceforge.net/projects/firebirdptbr.
For 2.0, see the collation PT_BR in CVS HEAD.


Adriano