Question config table returns latin1_swedish_ci

hi,
i changed my mysql table properties to utf8 but when i open kunena configuration page and press save, mysql table properties returns latin1_swedish. other tables are normal. it makes only config table. is there a code changing table language property at kunena? any idea about this problem?

Easy workaround /etc/mysql/my.cnf:
character-set-server=utf8
default-collation=utf8_unicode_ci

no man, you dont understand me, mysql default character set and collation properties are already utf8. the problem is fb_config table. when i make some changes and save at kunenas configuration page, the config table's collation returns latin1_swedish.

maybe it is a phpmyadmin issue

am i wrong or kunena drops config table and creates again after every configuartion save process?
i gues this isue related with it. and i if it is, i guess this can sign as a bug

Yes, it is a real bug, but only if your default charset in MySQL is something else than UTF8. I've already fixed this for K1.5.2, but my workaround should work as well.

Here's the real fix:

components/com_kunena/lib/kunena.config.class.php line 145 from:

to:

you are such a late man
i made it a little different way. i changed this:

$fields[] = "`$name` TEXT NULL";

to this:

$fields[] = "`$name` TEXT CHARACTER SET UTF8 COLLATE utf8_unicode_ci NULL";

changing only table charset doesnt work on me. so i handle with this way.

by the way, why kunena drops config table and creates again at save process, i really cant understand. is only writing datas to database not enough?

and another question (outside this issue) why all fields text or integer? for example even yesno areas are integer. doesnt this largen the database size? or mysql automatically set sizes of this fileds? i mean thousands of posts, or users etc...

thanks for help and answers.