Był sobie
- apache 1.3
- php 4
- mysql 4.1
Jest
- apache 2.2
- php 5.2
- mysql nie ruszony
w mysql (nie ruszony w czasie upgrade)
Kod
[client]
default-character-set=latin2
[mysqld]
default-character-set = latin2
language = /usr/share/mysql/polish/
[mysql]
default-character-set = latin2
default-character-set=latin2
[mysqld]
default-character-set = latin2
language = /usr/share/mysql/polish/
[mysql]
default-character-set = latin2
Dostaje zatem (zgodnie z my.cnf informacje):
Kod
mysql> \s
--------------
mysql Ver 14.7 Distrib 4.1.21, for slackware-linux-gnu (i486) using EditLine wrapper
Connection id: 7
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 4.1.21-log
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin2
Db characterset: latin2
Client characterset: latin2
Conn. characterset: latin2
UNIX socket: /var/run/mysql/mysql.sock
Uptime: 151 days 1 min 51 sec
Threads: 1 Questions: 13479683 Slow queries: 2 Opens: 1294 Flush tables: 1 Open tables: 2562 Queries per second avg: 1.040
--------------
mysql Ver 14.7 Distrib 4.1.21, for slackware-linux-gnu (i486) using EditLine wrapper
Connection id: 7
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 4.1.21-log
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin2
Db characterset: latin2
Client characterset: latin2
Conn. characterset: latin2
UNIX socket: /var/run/mysql/mysql.sock
Uptime: 151 days 1 min 51 sec
Threads: 1 Questions: 13479683 Slow queries: 2 Opens: 1294 Flush tables: 1 Open tables: 2562 Queries per second avg: 1.040
Problem jest z polskimi literami (krzaczki). Przed upgrade apache/php chodziło.
Teraz
1. wyświetlanie "statycznych" tekstów na stronie - OK
2. wyświetlanie tekstów z bazy:
- wyświetlanie pobranych tekstów z bazy na stronie - błędy z polskimi literkami
- wyświetlanie tekstu z bazy przez phpmyadmina - OK
Jak to naprawić? O czym googlować?
Zmiany w plikach stron odpadają
pozd