Blogs by tag: mysql http://my.afterdawn.com/latest_blog_entries.cfm All blogs are stored at my.afterdawn.com. hourly 2 Two days of UTF-8 happiness http://my.afterdawn.com/drd/blog_entry.cfm/3330/mixing_utf8_columns_to_latin1_mysql_database_and_getting_away_with_it Had "one of those days" .. actually two of them. With the joys of trying to make sense to the swamp called character encoding. Now, to explain the situation, you must understand the difference between ISO-8859-1 (and its sister, ISO-... Moving UTF-8 encoded data from latin1 table to another latin1 table.. http://my.afterdawn.com/drd/blog_entry.cfm/2884/convert_utf8_data_stored_in_latin1_table_to_latin1_data_in_latin1_table Encountered weird problem today, when moving data from an ancient Wordpress installation to AfterDawn's own table structure. Apparently, for whatever reason, WP's tables were set by default to be in latin1 encoding, but the data that WP inserted to those ... Sharding a forum database http://my.afterdawn.com/drd/blog_entry.cfm/2224/splitting_up_a_forum_database Ok, this is just me thinking out loud, nothing to prove my theory or correctness of my thinking yet, but wanted to put something in paper anyway, in case something comes up and I forget the concept before having time to work on the process.. Anyway, ev...