smallapple.net

[the one]

The server has problem with post contains unicode characters...Can the admin take a look?

[nhyone]

Never post in the right folder, how to take a look?

I've converted selected table columns to Unicode. Subject and body should now allow UTF-8. All other fields do not.

I wonder why the database wasn't in Unicode in the first place?

I'm not confident enough to convert all columns to Unicode...

[nhyone]

Okay, I've bitten the bullet and converted every table to UTF-8 (after backing up, of course). I hope everything still work.

A little SQL knowledge is useful:

USE information_schema;

SELECT CONCAT('ALTER TABLE ', table_name, ' CONVERT TO CHARACTER SET utf8;') FROM tables WHERE table_schema = 'db_name';

And then execute the output.