0

I have a form from which i am taking user details.I am seeing that when the user enters character like ' there is an entry in the table but the character is entered as ? in the DB. For Example : If a user enter : BCG [Nov-14 - Current].This is getting entered as BCG [Nov?14 ? Current] in the table.I am using MySQL.Please Help

Uday Khatry
  • 449
  • 1
  • 8
  • 23
  • I believe your question is already answered here: http://stackoverflow.com/questions/4384180/how-to-deal-with-quotes-and-apostrophes-for-string-comparison-in-mysql-so-they-m – Toni Brandt Jan 01 '15 at 19:57

2 Answers2

0

Make sure your database table encoding is set to utf8. You can verify by running dumping the table schema from command line:

bash $ mysqldump -p > debug.sql

For older MySQL version, the default encoding is latin1

Vic
  • 53
  • 5
  • Hi Vic,You are correct.My default encoding is latin1.So how can i change the default encoding and also now if i change my default encoding to utf8 then can it impact many other factor? – Uday Khatry Jan 01 '15 at 20:08
  • http://stackoverflow.com/a/6115705/357092 – Vic Jan 03 '15 at 22:39
0

If you are using MySQL Workbench, right-click on the schema and choose "Alter Schema...". Now you will have a select list labelled "Collation". Choose utf8 and click on Apply.

Toni Brandt
  • 1
  • 1