php Spreadsheet_Excel_Reader data contain unwanted � when insert into mysql database

Question

When read a Excel file using Spreadsheet_Excel_Reader data contain unwanted � between each characters,When insert it into mysql DB. How to solve this issue

Community · Accepted Answer · 2017-05-23 10:33:38Z

0

Sounds like a character set mismatch. This question on SO might help re. the spreadsheet: php-excel-reader - problem with UTF-8 and then check that your tables/columns are using the same (ideally UTF-8) character set, and that your connection is also using UTF-8.

edited May 23, 2017 at 10:33

CommunityBot

11 silver badge

answered Sep 16, 2014 at 12:20

Matt Parker

2841 silver badge3 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

php Spreadsheet_Excel_Reader data contain unwanted � when insert into mysql database

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related