![]() So either I need to add something to the sqlite3 program or there is a bug.īTW, I copied the new database file to my android program and find out that my app can handle (read for text to speech) the Unicode data just fine so I apparently don't have an issue anymore. When I Browse the table's data in "DB Browser for SQLite" the same Unicode fields shows as a BLOB. save "C:\\Historical Marker\\Historical Markers.db" import "C:\\Historical Marker\\Input\Markers.csv" Markers I go to the directory "C:\Program Files\DB Browser for SQLite\sqlite-tools-win3500" that has the sqlite3 executable and start it. ![]() My android app changes any of these to a single quote. When browsing the table's data the Unicode characters are shown with the black diamond and a white question mark in it. I get a dialog with the following fields, Table Name filled in with the table name taken from the csv file, Column names in first line - checked, Field separator - comma, Quote character - double quotes, Encoding - UTF-8, and Trim fields - checked. Then I select the csv file that contains the Unicode characters from my PC file system. After starting "DB Browser for SQLite" on my PC I select "File > Import > Table from CSV file.". I have a csv file that has Unicode data in it. Larry, I am sorry that my explanation of my issue was not clear enough for you.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |