Apostrophe changes to unrecognisable symbol (blank square) when uploading csv to HubDBSOLVE
08-30-2017 01:41 - edited 08-31-2017 09:41
When I upload a csv file to HubDB where text includes apostrophes (') render as an unrecognisable symbol when appearing on the live webpage.
e.g. "aren't" uploaded to a "text" column renders with a blank square symbol in the apostrophe's place. (image below)
I have tried to upload to a text and a rich-text column where the issue has occured on both occasions.
When I edit the text within the HubDB table, changing the symbol to an apostrophe it correctly appears on the live webpage. The issue only seems to arise when importing a file into HubDB.
How can I ensure this will not happen on an csv upload?
When entering data into Excel before upload, the data was copy+pasted, as values.
Needed to manually type out.
Solved! Go to Solution.