Characters in DB displaying strangely

2018-06-21 15:55:55

I'm creating a trivia iPhone app. I've written 1,000 questions or so in the mac app Numbers. The problem I'm having is that when I export the document to a CSV then open it in mySQL lite and save it as a database for the app, things like apostrophes turn out strangely for example "there's" would turn out as thereás instead. Is there any easy way to correct this issue?

Thanks,

Chris

This is happening because you are generating the CSV file from a MS doc or excel file

where

if i write " There's " in MS Doc(look the apstrophe character)

but if i write same text in a simple text file " There's " (look the changed apstrophe character)

That is why the text is displaying as thereás due to character encoding problem.

So you have to change the ( ' )character in to ( ' ) to display it correctly.

链接地址: http://www.djcxy.com/p/60826.html

上一篇: 是否有可能在xcode4中自定义不可见的字符？

下一篇: 数据库中的字符奇怪地显示