PostgreSQL vs. MySQL

[Zakkr]

On Wed, 22 Sep 1999, Horak Daniel wrote:

> > 	Proste chci vedet co je pravdy na tom co tu jiz 
> > nekolikrat zaznelo:
> > "PostgreSQL je pomala potvora.." a rad bych mel v rukou 
> > nejaka data a ne
> > emoce..
> 
> Pokud jsem dobre sledoval thread "[HACKERS] All things equal, we are still
> alot slower then MySQL?" v pgsql-hackers, tak PostgreSQL neni zase az tak
> pomala potvora.

Prave proto to zkousim a zatim se mi zda, ze PosgreSQL je dokonce
rychlejsi.. a o MySQL zacinam zjistovat zajimave veci:

napriklad nasledujici me malem srazilo ze zidle:

(MySQL Reference Manual for version 3.22.25.)

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".


 ---- to tam bylo vzdy? (mam pocit, ze kdyz jsem naposledy (cca 1 rok) neco 
delal s MySQL tak LIKE byl case-sensitive...) nebo ne?

							Zakkr