I have a field with latin1_swedish_ci
collation and inserted data is visible to me as a set of question marks ????????
.
How to convert existing (??)question mark data with original data?
Note:(???)question mark data in table in actually in gujarati language data.
I am using code-igniter,mysql and phpmyadmin
3
Answers
Cause
The default encoding for inbound connections isn’t set properly. DEFAULT CHARSET will return as utf8 however character_set_server will be something different. In the above, the character_set_server was set as latin1.
Resolution
Set default-character-set=utf8, as detailed in
Configuring Database Character Encoding.
Try changing the column’s character set
sample code is below.
Note:
When records are already ??????? in the table, the data to be reinserted again.
The existing data will not change once collation changes.
Most probably you can change the collation through the phpmyadmin page
Follow this steps
Change the collation and click GO