smf 2.0.2 to vb 4.2.0 Impex error and problem with some character
 

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:

Quote:
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:

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: ' è é i à o ù ....
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?