The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Did you change the character set doing https://stackoverflow.com/a/6115705/6275228 ?
|
#3
|
|||
|
|||
Yes, I have, but that didn't work.
|
#4
|
|||
|
|||
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.
|
#5
|
|||
|
|||
No, it's DirectAdmin.
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|