![]() |
Strange characters in database and how to make them readable
Hi, my database charset and all the vBulletin charsets are "latin1_swedish_ci".
In some tables like username or posts, I see characters that are strange to me, but are readable by the server to convert them to the correct letters. Like this Quote:
I tried changing all tables and vb database to utf8_persian_ci, and also ut8mb4_persian_ci and ut88_general_ci, and I changed the collation of all tables to these, but nothing converted. How can I fix this? Both for the existing data and the future data. |
Did you change the character set doing https://stackoverflow.com/a/6115705/6275228 ?
|
Yes, I have, but that didn't work.
|
Is it a plesk server, if so, plesk has a nasty issue of setting a local php.ini with a charset entry & its forces sql to use UTF8.
|
No, it's DirectAdmin.
|
All times are GMT. The time now is 12:49 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|