PostgreSQL vs. MySQL

[Ondrej Koala Vacha]

On Wed, 22 Sep 1999, Zakkr wrote:

> 
> 
> 17.13 Case sensitivity in searches
> 
>    By default, MySQL searches are case-insensitive (although there are
>    ^^^^^^^^^^                     ^^^^^^^^^^^^^^^     
>    some character sets that are never case insensitive, such as czech).
>    That means that if you search with col_name LIKE 'a%', you will get
>    all column values that start with A or a. If you want to make this
>    search case-sensitive, use something like INDEX(col_name, "A")=0 to
>    check a prefix. Or use STRCMP(col_name, "A") = 0 if the column value
>    must be exactly "A".
> 


V nejakych drivejsich verzich implicitne opravdu byla insensitive, ale ted
je sensitivni default.


---
Ondrej Koala Vacha