mysql, LMS, UTF-8

[Przemysław Backiel]

Witam,

mam jazde od samego rana..

czysty system

tworze baze danych:


mysql> CREATE DATABASE lms CHARACTER SET utf8 COLLATE utf8_polish_ci;
mysql> GRANT USAGE ON lms.* TO lms w localhost;
mysql> GRANT ALL ON lms.* TO lms w localhost IDENTIFIED BY 'twoje_hasło';
mysql> flush privileges;
mysql> use lms;
mysql> source doc/lms.mysql;


i jak wpisze nazwisko, np. ŚLIWIŃSKI
apacze nie wyswietla poprawnie, robi krzaczki


jak z konsoli sobie zrobie takie

SELECT * FROM users;
widze śliwiński

mysql> SELECT lastname from users where lastname='ŚLIWIŃSKI';
+-------------+
| lastname    |
+-------------+
| ŚLIWIŃSKI |
+-------------+


[przemek w vitaa /etc]# locale
LANG=pl_PL.UTF-8
LC_CTYPE="pl_PL.UTF-8"
LC_NUMERIC="pl_PL.UTF-8"
LC_TIME="pl_PL.UTF-8"
LC_COLLATE="pl_PL.UTF-8"
LC_MONETARY="pl_PL.UTF-8"
LC_MESSAGES="pl_PL.UTF-8"
LC_PAPER="pl_PL.UTF-8"
LC_NAME="pl_PL.UTF-8"
LC_ADDRESS="pl_PL.UTF-8"
LC_TELEPHONE="pl_PL.UTF-8"
LC_MEASUREMENT="pl_PL.UTF-8"
LC_IDENTIFICATION="pl_PL.UTF-8"
LC_ALL=pl_PL.UTF-8


w phpmyadmin widze źlę, w LMSie widze źlę

na old maszynie jest ok


co moglem skabanić ?






-- 
Z powazaniem
Przemyslaw Backiel