CODEWITHSUNDEEP
databaseexcelsqlitespecial-characters
rohan panchal
rohan panchal

Reputation: 881

Characters are converted in special symbols

I have database records available in MSExcel file. I save it as CSV file. And then create database in firefox's SQLiteManager by importing that CSV file .

But the characters like ..., ' , ",- are converted in �.

I have also tried to save CSV file in UTF-8 formate, but it converts that characters in Õ

Has anyone idea , how to solve it?

Thanks.

Upvotes: 0

Views: 116

Answers (1)

woodykiddy
woodykiddy

Reputation: 6455

Perhaps you might want to consider escaping quotes, e.g. try "" or "' in your csv file. And just pay a bit more attention to Fields enclosed by section in SQLiteManager add-on, making sure these fields are enclosed properly.

Upvotes: 1

Related Questions