I've set my database (tables, columns etc) to the proper collation already (utf8 general) but K2 is writing nothing but ???? (question marks) in my article and to the database.

 

I am able to create articles with UTF8 characters in the title and content through the standard Joomla Content manager without a problem. Can someone help me?

My collumns didn't change collation apparently. This will convert all tables and columns to utf8_general.

Found the script here: stackoverflow.com/questions/105572/a-script-to-change-all-ta...

 

mysql -u YOURMYSQLUSERNAME -pYOURMYSQLPASSWORD --database=YOURDATABASENAME -B -N -e "SHOW TABLES" \ | awk '{print "ALTER TABLE", $1, "CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;"}' \ | mysql --database=YOURDATABASENAME -u YOURMYSQLUSERNAME -pYOURMYSQLPASSWORD &

 

 

dfhdfg