Today Something wrong with encoding in opencart – I cannot save the city with special language characters, like raga, but found out that it is database field error.
When I insert raga, it is inserted as R?ga. ? marks in place of special characters
So I have to find out why this is happening, I check the code all working fine and at last, saw the database table field have collation ofÂ latin1_bin so I changed it toÂ utf8_bin and the special character is saved on the database and the same are shown correctly.
So while making the database table keep these things into mind, if you have to save multi-language thenÂ utf8_bin is to be set on the collation