AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: Sam_78 on January 09, 2017, 10:21:40 AM

Title: Database entry issue
Post by: Sam_78 on January 09, 2017, 10:21:40 AM
Hello folks!
Hope you all had a wonderfull weekend
I am facing an issue here which is when I add content on the Description in Category I can't type  “  instead I have to type "  the inverted comma
IF I type “ it doesn't save it just erases everything in my description and if I add " it works.. Also there are few other characters that has the same effect
I guess its the issue when I set up Database.. Any help is really appreciated
Thanks
Title: Re: Database entry issue
Post by: abolabo on January 09, 2017, 10:52:21 AM
hi. You should to check collation of the database tables, For ex. category_descriptions. it must be utf8_general_ci

if not, you can change it. Please read  this  (http://stackoverflow.com/questions/742205/how-to-change-the-default-collation-of-a-table) for details

Note. Do not forget do full database backup before any operations with database.
Title: Re: Database entry issue
Post by: Sam_78 on January 09, 2017, 11:38:15 AM
Thanks for the reply
I did check my collation and it is utf8_general_ci but still it doesn't work
Title: Re: Database entry issue
Post by: abolabo on January 11, 2017, 12:13:10 PM
Do you checked data via phpMyAdmin? What is there as "qoutes"?