1 Topic by Fenixoid (edited by Fenixoid 2007-03-21 08:39)

  • Registered: 2007-03-21
  • Posts: 2

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 ?????????

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Charset problem in mysql?

What charset is your language pack using?

3 Reply by Fenixoid (edited by Fenixoid 2007-03-21 10:42)

  • Registered: 2007-03-21
  • Posts: 2

Re: Charset problem in mysql?

Charset in language does not matter, it's about writing data tu mysql ant taking from it.

When I write ????????? leters in post, there's no text added in post or database.
When I write ????????? letters directly in database, the output looks like Ä?ĨÄ?Ä?Ä?ĨÄÆÄ?Ä?ÄÆÅ?Å?ÄÆųÅ?ųūųū()-(ž


Language pack is Lithuanian (http://punbb.org/download/lang_packs-1.2/Lithuanian.zip), charset is not defined there, but I guess it's windows-1257 ir ISO-8859-13.

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Charset problem in mysql?

Lithuanian language pack wrote:

'lang_encoding'            =>    'windows-1257',

Try changing it to UTF-8