Forum Character Set and Collation Housekeeping: Pre-vB5 upgrade prep.

[محروم.كوم]

<div>I've been putting this off, but it's time to address the character set and collation issues on our vBulletin v4.2.0 PL2 database. I'd appreciate some folks helping me square this away...

Forum is in the US... The whole Latin1 vs. UTF8 thing... driving me crazy. I'd really like to take my database all the way Latin OR all the way UTF8.

Here's what I have right now:

vBulletin Language-->General: HTML Character Set = ISO-8859-1


SHOW VARIABLES LIKE '%character%'character_set_clientutf8character_set _connectionutf8character_set_databaselatin1charact er_set_filesystembinarycharacter_set_resultsutf8ch aracter_set_serverlatin1character_set_systemutf8ch aracter_sets_dir/usr/local/mysql-5.0.96/share/mysql/charsets/


SHOW VARIABLES LIKE '%collation%'collation_connectionutf8_general_cico llation_databaselatin1_general_cicollation_serverl atin1_german2_ci

And to clarify for the database settings (these are being read from phpmyadmin)
Database Character Set: utf8 __DEFINE_LIKE_SHARE__