PDA

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.