Topic: Charset problem in mysql?
Hi,
I have this trange problem with my language charset in forums.
Server is running PHG 5.2 ant MySQL 5.0.26. Default charset for MySQL databases ir utf8_general_ci.
Same in mysql my.cnf:
[mysql]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqladmin]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlcheck]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqldump]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlimport]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlshow]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[myisamchk]
character-sets-dir=/usr/share/mysql/charsets
[myisampack]
character-sets-dir=/usr/share/mysql/charsets
[mysqld]
character-set-server = utf8
default-character-set = utf8
I installed phpBB2.0.22 and punBB. When I write a topic or create a category with lituanian charsets, they a not shown, or the text is cutted of from the beginning of lithuanian characters.
I tried to change the database ir table charset to latin1, cp1257, utf8_lithuanina_ci and so on - no effect. The lithuanian characters a not show or there're some strange simbol's in that place, like Ä?Ä?ĨĨÄ?Ä?žžž
Has anybony had such error? Any solutions for them?
Lithuanian characters are ?????????