vb.org Archive - Russian chars in MySQL are Ok but no in the forum

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)

- - Russian chars in MySQL are Ok but no in the forum (https://vborg.vbsupport.ru/showthread.php?t=282815)

Russian chars in MySQL are Ok but no in the forum

Hello!

we are developing a forum, then we have found this error:

we set up in the MySQL (via phpmyadmin) the encoding for the MySQL into UTF-8 because we are importing information in Russian language, then we have found this mistakes:

1.- in the MySQL database we can read fine the text but not in the forum (see images please)

2.- In the admincp language english we set up also the encoding in UTF-8

3.- but in theforum we see weird signs like ????

what did i forgot?

any help would be appreciated

Quote:

Originally Posted by ntldr1962 (Post 2328635)

I don't think that you used the right way, especially if you have already data in your database.

Using COLLATE utf8_general_ci is not the right choice. Better use utf8_unicode_ci
Changing it from phpMyAdmin is also not correct, especially when you're also changing charset eg from iso-8859-1 to utf8 avoid to use phpMyAdmin.
The best way is to do the changes from the command line if you've shell access.
Finally, after conversion you need to change the data from your backup sqldump (hope you know that you've to get a full database backup before such actions), by using iconv

Chris

ok let me try to perform the actions that you recommend =)

thanks in advance

Ready! we solved it thank you!

at the end we used a php script to convert the Database, and also "DONT FORGET" to put in languages in the Admincp "utf8" not UTF-8

here is my simple script:

Quote:

<?php

// Fill in your configuration below
$db_server = 'server';
$db_user = 'user';
$db_password = 'pass';
$db_name = 'db';
$char_set = 'utf8';

header('Content-type: text/plain');

$connection = mysql_connect($db_server, $db_user, $db_password) or die(mysql_error() );

$db = mysql_select_db($db_name) or die( mysql_error() );

$sql = 'SHOW TABLES'; $result = mysql_query($sql) or die( mysql_error() );

while ( $row = mysql_fetch_row($result) )
{
$table = mysql_real_escape_string($row[0]);
$sql = "ALTER TABLE $table DEFAULT CHARACTER SET $char_set COLLATE utf8_unicode_ci";
mysql_query($sql) or die( mysql_error() );

print "$table changed successfully.\n";
}

// Update the Collation of the database itself
$sql = "ALTER DATABASE CHARACTER SET $char_set;";
mysql_query($sql) or die( mysql_error());

print "Database collation has been updated successfully.\n";

// close the connection to the database
mysql_close($connection);

?>

Altering the DEFAULT collation of your existing tables is not enough. You also need to alter the collation of each column in the table, because it will still keep the old collation. The default is only used for new columns that are added. Learned this the hard way myself.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01040 seconds Memory Usage 1,725KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: