zmena nastaveni mysql (Lenny)

[hoffmann]

Ahoj,
potreboval bych zmnenit nize uvedene promene v Mysql na cp1250_czech_cs.

collation connection     utf8_unicode_ci
(Globální hodnota)    latin1_swedish_ci
collation database    latin1_swedish_ci
collation server    latin1_swedish_ci

Predem dekuji.

[vlado.strenk]

tak posli IP a heslo na roota :-)
Dobra rada: zabudni na CP1250 pouzivaj UTF8
to czech_cs by mal byt czech_ci
utf8_czech_ci

[Roman Horník]

CP-1250 = zmrvený ISO-8859-2 = obstarožní kódování odsouzený k zániku

Jak psal Vlado, UTF-8 rulezzz!

[vlado.strenk]

Inak v /etc/mysql/my.cnf

[mysqld]
init_connect='SET CHARACTER SET utf8'
init_connect='SET collation_connection = utf8_czech_ci'
init_connect='SET NAMES utf8'
default-character-set = utf8
character-set-server  = utf8
collation-server      = utf8_czech_ci

[Erich Stark]

tak posli IP a heslo na roota :-)
Dobra rada: zabudni na CP1250 pouzivaj UTF8
to czech_cs by mal byt czech_ci
utf8_czech_ci

Naco by ti bolo heslo ak by mal nastavene "PermitRootLogin no" ? :)