First issue I'm facing when import users:
Issue: http://screenshotuploader.com/s/01/ymDvOLER
Solution: http://screenshotuploader.com/s/01/x9tOBR6Li
I have to change collation to from latin1_swedish_ci to utf8_general_ci then the error is fixed
I continue with import forum, but it display as NOT as expected as below:
web: http://screenshotuploader.com/s/01/5E4BL76I
phpmyadmin:
http://screenshotuploader.com/s/01/YIwT33E2E/
phpmyadmin - original data:
http://screenshotuploader.com/s/01/TEQYpyZ9d
After investigation, I figure out that I have to change collation at table 'forum' for field 'title' and 'description' must be 'utf8_general_ci'.
After change collation, the text is imported same as original:
http://screenshotuploader.com/s/01/N0mfhzE7h
>> I'd like to ask if we have another solution for this ? Do I have to change all collation to every field of vbb4 database ?! what is the use_utf8_encode and decode used for ?
Please advise,
Thanks in advance!
FYI, the config I used:
\impex\ImpExFunction.php
// Advanced Target
$impexconfig['target']['databasetype'] = 'mysql';
$impexconfig['target']['charset'] = 'utf8';
$impexconfig['target']['persistent'] = false;
// Advanced Source
$impexconfig['source']['charset'] = 'utf8';
$impexconfig['source']['persistent'] = false;
//utf8
define('use_utf8_encode', true);
define('use_utf8_decode', true);
$config['Mysqli']['charset'] = 'utf8';
Comment