Problem with charset after import from vb3

[bela-meaad]

Hello there,

i have a lot of errors with my database,
so i decided to import important tables from the old database to the fresh database,

i changed the charset to:
$impexconfig['target']['charset'] = 'windows-1256';
&
$impexconfig['target']['charset'] = 'windows-1256';

the database MySQL connection collation for both are same
latin1_swedish_ci

but stil i got strange character
أ£أڑأ‡أ¤أ أ‡أ،أ“أچأ‡أˆ

any one would like to help?

Edit: while importing the users , thread & post it looks fine with arabic language

Regards

[Steve Machol]

Try this. Edit impex/db_mysql.php and change this line:

$query_id = $query_type(utf8_encode($query_string), $this->link_id);

To this:

$query_id = $query_type($query_string, $this->link_id);

Then redo the import. Let me know if that works.

[bela-meaad]

thats work

thanks a lot

[Steve Machol]

Glad it worked.

[bela-meaad]

i tried to import from
UTF-8
To
UTF-8
after converting the database from windows-1256 to UTF-8
after converted it works fine
but as i said i want to import it to fresh vb because of errors i have with my forum.

it works but with some encoding error
some letters dosen`t show

example after importing:

تر�*يب

& it suppose to be as the original forum i have converted to UTF-8:

ترحـيب


i hope its clear

thanks

[bela-meaad]

Up

still need help

[Steve Machol]

Sorry I don't understand what you mean. I thought you said you tried my suggestion worked in post #3.

[bela-meaad]

No worries

that fixed
its hard to explain it here

Thanks

[Oras]

Same problem here .. can you kindly tell me how you fixed it?
Thank you
Oras

[Steve Machol]

Try post #2.

[Jerry]

Same problem here .. can you kindly tell me how you fixed it?
Thank you
Oras

All char set processing has been removed from ImpEx, unless you specify it in ImpExConfig now, the ideal is to set the source and target database to use the same as well as vBulletin in the admincp.

[djilou]

All char set processing has been removed from ImpEx, unless you specify it in ImpExConfig now, the ideal is to set the source and target database to use the same as well as vBulletin in the admincp.

where in the admincp ?
Langage Manager => Edit settings => HTML Character Set ??

[Jerry]

where in the admincp ?
Langage Manager => Edit settings => HTML Character Set ??

Yes.