Imam charset problem sa bazom na blogotku koji je ocigledno uzrokovan cinjenicom da nisu svi parametri prilikom upisivanja podataka bili utf8. Ranije mi taj problem nije smetao posto su se strane prikazivale okay ali sada prebacujem kod na CI tako da zelim da resim taj problem (pogadjate, sa CI-om nasi karakteri ne izgledaju kako treba).
Inace sve tabele u bazi su utf8 sa default collation-om (utf8_general_ci). Podaci se upisuju od strane feed parsera, prilikom upisa niti ispisa (web utf8) nije pokrenut "set names utf8" tako da su koliko vidim neki od connection parametara latin1.
Evo kako izgledaju variable na serveru sa default podesavanjima i utf8:
Kôd:
mysql> show variables like '%char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
mysql> set names utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> show variables like '%char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
Svi saveti dobrodosli
