Hello i have a problem to import smf 2.0.2 to vb 4.2.0 Patch Level 3 with impex.
Local using Xampp i try to install vb and using impex import smf and got the error:
I don't have a great knowledge of php but looking at this forum and on google there are errors due to different Collation and charset using in db.
In fact smf use utf8_general_ci and vb use latin1_swedish_ci
I try to create a new db with collation "utf8_general_ci" and install a new fresh vb installation using Msqli but even before running impex i start a new thread to test vb with some character: ' è é ì à ò ù ....
These characters are not displayed and all nomal text after these are not displayed.
For example if i write:
I don't like the rain
after reply vb show only:
I don'
Any suggestions to resolve this and impex error?
Local using Xampp i try to install vb and using impex import smf and got the error:
ImpEx Database error
mysql error: Invalid SQL: SELECT username FROM vb_user WHERE username = 'Cam166°vva'
mysql error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
mysql error number: 1267
Date: Sunday 11th 2012f November 2012 12:50:56 PM
Database: fnc
MySQL error:
mysql error: Invalid SQL: SELECT username FROM vb_user WHERE username = 'Cam166°vva'
mysql error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
mysql error number: 1267
Date: Sunday 11th 2012f November 2012 12:50:56 PM
Database: fnc
MySQL error:
In fact smf use utf8_general_ci and vb use latin1_swedish_ci
I try to create a new db with collation "utf8_general_ci" and install a new fresh vb installation using Msqli but even before running impex i start a new thread to test vb with some character: ' è é ì à ò ù ....
These characters are not displayed and all nomal text after these are not displayed.
For example if i write:
I don't like the rain
after reply vb show only:
I don'
Any suggestions to resolve this and impex error?
Comment