View Full Version : encoding problem
persiangulf
09-23-2009, 11:53 AM
Hi I want to show last topics of vbulletin in my web site and issue the following query but when i read them from database i get the result in incorrect encoding(encoding of database and tables are utf-8).
SELECT * FROM vbulletin_thread ORDER BY threadid DESC LIMIT 15
how can i get them in correct encoding
Lynne
09-23-2009, 02:11 PM
Can we see the exact code you are using and the exact error you get? (And perhaps replace * with just the fields you need.)
persiangulf
09-23-2009, 03:35 PM
i want title and postusername fields of thread table. the collation of tables and database is utf8_persian_ci and i need it as utf8_persian_ci.
I saw the content of database with phpmyadmin it is exactly that i get(باز شد٠ÙرÙشگا٠ساÛت not باز شدن فروشگاه سایت).
I think i should convert the content of fields but i don't know how and don't know what charset is set into database
persiangulf
09-26-2009, 06:53 AM
I'm waiting for answer, thanks.
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.