Foreign characters get converted to question marks
Permalink
I'm having an issue on a client's site where foreign language characters get converted into question marks (???) after a block is saved.
Does this mean that the database is not set up for UTF-8 characters? I've tried to make sure that my theme is UTF-8 encoded, but it doesn't seem to make a difference. It looks fine while editing and adding a block, but it returns as question marks after I'm finished adding or editing the block.
Does this mean that the database is not set up for UTF-8 characters? I've tried to make sure that my theme is UTF-8 encoded, but it doesn't seem to make a difference. It looks fine while editing and adding a block, but it returns as question marks after I'm finished adding or editing the block.
yea i think its the database since all content is saved to it and the database doesn't know how to save the characters so it makes it into question marks.
I faced this problem when using the Arabic locale. I had to:
- Use utf8_general_ci collation for mysql
- Use ar_XX.UTF-8 for locale
- and ofcourse utf-8 encoding for my theme.
- Use utf8_general_ci collation for mysql
- Use ar_XX.UTF-8 for locale
- and ofcourse utf-8 encoding for my theme.
"I'm having an issue on a client's site where foreign language characters get converted into question marks (???) after a block is saved."
I have the same problem, version 5.4.2.2 . I am not a programmer, does anybody have a solution?
I have the same problem, version 5.4.2.2 . I am not a programmer, does anybody have a solution?
hello,
I just had to deal with that and although at first I thought it was a database problem, in the end it was a php setting.
Check in your php setting you will probably find charcater encoding is set to some iso format instead of utf-8, just change it in your php.ini
However what has already been saved with weird characters will remain that way until you correct it back to normal character as it was saved like that in the database. But in the future, you should not have that problem again (well at least it worked for me)
I just had to deal with that and although at first I thought it was a database problem, in the end it was a php setting.
Check in your php setting you will probably find charcater encoding is set to some iso format instead of utf-8, just change it in your php.ini
default_charset = "utf-8"
However what has already been saved with weird characters will remain that way until you correct it back to normal character as it was saved like that in the database. But in the future, you should not have that problem again (well at least it worked for me)
