Re(2): Queries. Question to all

[Ruslan Zasukhin]

On 6/30/04 1:49 PM, "Peter Knobloch" <peter.knobloch at absus.at> wrote:

Hi Peter,

> Hi Ruslan,
> 
>> I am not sure about mySQL
> "LIKE" is case insensitive, "LIKE BINARY" case sensitve
> 
>   http://dev.mysql.com/doc/mysql/en/String_comparison_functions.html#IDX1312

Ok, I see that staring with 4.0 mySQL do case-insensetive LIKE, REGEX,
STRCMP, ...

I think we will check other DBMS as SQL Server and Sybase.
Also we need check SQL92 stadnard.


> Furthermore, in mySQL "LIKE" uses an index if possible.
> 
>   http://dev.mysql.com/doc/mysql/en/MySQL_indexes.html#IDX777>

This have no sense for Valentina actually.

Valentina is design in such way, that we do not need this in general case.

Although FIELD LIKE "start non wildacrd" really is equal to our left() =


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------