Developer

Here it is Ïðèâåò! ß òóò âïåðâûå SHOW VARIABLES LIKE 'character_set_database'; returns this on old database Variable_name Value character_set_database latin1 Database collation is set to latin1_swedish_ci All tables had collation set to latin1_swedish_ci SHOW VARIABLES LIKE 'character_set_database'; The new DB returns Variable_name Value character_set_database utf8 Database collation is set to utf8_unicode_ci All tables have collation set to utf8_general_ci I have also tried to add these instructions to .htaccess as mentioned as per official instructions AddDefaultCharset utf-8 AddCharset utf-8 * <IfModule mod_charset.c> CharsetSourceEnc utf-8 CharsetDefault utf-8 </IfModule> By the way old database has had 148 tables and the converted one has 180. I guess that some data has been in UTF-8 in DB, but I am not sure about it. How may I check it? The problem with downloading,editing and uploading back is that the DB is 1.5 GB in size and I can only manipulate it on my server via SSH or similar way without downloading it. Also please note that my MySQL default charset is set to UTF-8 Unicode (utf8) and default MySQL connection collation is set to utf_unicode_ci

Hi, I have run the first script and it has gone well. I have then added this code to config file $INFO['sql_charset'] = 'utf8'; and upgraded to IPB 3.x Then I have set UTF-8 encoding from withing ACP. I can confirm that my database collation is now set to utf8_unicode_ci, but posts arent readable from within phpMyAdmin and the forum. Please advice what could have gone wrong?

Hello, I have a forum with Win1251 forum encoding and latin1_swedish_ci collation database. Can you please outline step by step instructions here? I am a bit lost with so many posts a few mentioned scripts. First I will need to make a backup and export my database as SQL file and then run your script from command line? Also could you please comment about these parameters? Note two important issues: - the "set names" command to the old encoding to read correctly from the database and -the "_utf8" modifier before the utf8 string at the UPDATE command to write to the database. without it, the script did NOT work. how? $old_char_set = "iso-8859-7"; In my case it will be Win1251? $alter_database=false; // if true,database and its tables (structure) will be converted to utf8 as well. NOTE: May alter length/type of some fields Should this be set to true? $autodetect_encodings="ISO-8859-7,UTF-8"; In my case Win1251, UTF-8? Has anyone tried this script yet? May it be that if I put it in config file and upgrade from 2.x to 3.x it will convert the database content to UTF-8 and the forum with UTF-8 encoding will start working just fine without running above script?

It has been two weeks since you have promised to get an answer for me,but I am still waiting for the reply.

Hello, I have order a paid programming in January 2009 and surprisingly the job has not been completed until now. I have tried to contact Customer Support with no luck. They have promised that someone will contact me "tomorrow" which was two weeks ago, but no one did contacted me. I dont see other choice than to complain publicly here on the board. Anyone care to explain me WHY my $120 value service has NOT been offered in the last 6 months? Should I wait for another 6 months to get this job done? See ticket 587929 for more details.