Re: [GENERAL-BG] php, mysq и кирилица

Quoting Nikolai Jeliazkov <[email protected]>:

> =C8=EC=E0=EC =EF=F0=EE=E1=EB=E5=EC:
> =E8=EC=E0=EC =E7=E0=EF=E0=EB=E5=ED mysql =F1=FA=F1 =F1=EB=E5=E4=ED=E8=FF =
=EA=EE=ED=F4=E8=E3=F3=F0=E0=F6=E8=EE=ED=E5=ED =F4=E0=E9=EB
> [client]
> port            =3D 3306
> socket          =3D /var/run/mysql/mysql.sock
> default-character-set=3Dcp1251
> [mysqld]
> port            =3D 3306
> socket          =3D /var/run/mysql/mysql.sock
> default-character-set=3Dcp1251
>
> =E2 =F2=E5=EA=F1=F2=EE=E2=EE =EF=EE=EB=E5 =E2 =F2=E0=E1=EB=E8=F6=E0 varch=
ar(255) =F1 =EF=EE=EC=EE=F9=F2=E0 =ED=E0 SQLYOG =F1=EB=E0=E3=E0=EC =F2=E5=
=EA=F1=F2
> =ED=E0 =EA=E8=F0=E8=EB=E8=F6=E0
> =EF=F0=E5=E7 ssh =EE=F2 =EA=EE=ED=E7=EE=EB=E0 =F1=FA=F9=EE =E3=EE =F7=E5=
=F2=E0 =ED=E0 =EA=E8=F0=E8=EB=E8=F6=E0
> =EE=E1=E0=F7=E5, =EA=EE=E3=E0=F2=EE =EF=F0=E5=E7 php =E3=EE =F7=E5=F2=E0 =
=E8=E7=EB=E8=E7=E0=F2 =F1=E0=EC=EE =E2=FA=EF=F0=EE=F1=E8=F2=E5=EB=ED=E8 ???=
???
> =F2=EE=E2=E0 =E5 =E5=E4=ED=E0=EA=E2=EE =E8 =EA=E0=F2=EE =E5 =EF=F0=E5=E7 =
apache-=F2=EE =E8 =EE=F2 =EA=EE=EC=E0=ED=E4=E5=ED =F0=E5=E4
>
> =E8=ED=E0=F7=E5 =F1=FA=EC =F1 trustix 2.2
> =ED=FF=EC=E0 =E7=ED=E0=F7=E5=ED=E8=E5 =E4=E0=EB=E8 =E8=E7=EF=EE=EB=E7=E2=
=E0=EC php4 =E8=EB=E8 php5
>

Probvaj da izpylnish "SET NAMES cp1251";

andrey@lmy004:~> php -r 'mysql_connect("localhost",
"andrey","");var_dump(mysql_fetch_array(mysql_query("SELECT * FROM
test.xyz")));'
array(2) {
   [0]=3D>
   string(12) "??????????"
   ["a"]=3D>
   string(12) "??????????"
}
andrey@lmy004:~> php -r 'mysql_connect("localhost",
"andrey","");var_dump(mysql_query("SET NAMES
cp1251;"));var_dump(mysql_fetch_array(mysql_query("SELECT * FROM 
test.xyz")));'
bool(true)
array(2) {
   [0]=3D>
   string(12) "=E0=ED=E4=F0=E5=E9"
   ["a"]=3D>
   string(12) "=E0=ED=E4=F0=E5=E9"
}

Problemyt e che [client] sekciata ne se izpolzva ot PHP, a e samo za 
konzolniat
klient, kakto [mysqldump] e za mysqldump i t.n. Syshto taka ext/mysql niama
funckiata, koiato da zadava kodova tablica, neshto koeto go ima v 
novite versii
na ext/mysqli. Samo che novata funkcia izpylniava "SET NAMES", taka che e v=
se
syshtoto.

Uspeh!
Andrey