If I import a csv file using DB Browser for SQLite in Windows that contains Unicode such as below it replaces it with a replacement character � but if I import using sqlite3.exe it displays as BLOB viewing it using DB Browser for SQLite. When used in my Android app in a Listview the Unicode displays as a box but the ascii code displays normally. Is there a way to import a csv file using sqlite3.exe like how DB Browser for SQLite does? DB Browser uses UTF-8 but I am letting sqlite3.exe use the default in my VBScript.

Lincolnﾒs Farewell to Springfield

When, in a sqlite3 session, I run this: .import -csv stuff.csv MyStuff , where the file named "stuff.csv" contains exactly this: stuff Lincolnﾒs Farewell to Springfield , I get a table containing one row which contains the exact same UTF-8 as can be seen above as the 2nd line in "stuff.csv". This is working precisely as designed and documented.

Your issue is with DB Browser for SQLite. I can assure you that the sqlite3 shell is not going to have its .import behavior changed to do something which is obviously incorrect as you are describing.

Define what you mean by "displays as BLOB"?

Do you mean that it displays ink-blot images to you to perform a psychological examination of you? What was the result?

Anything which displays a "replacement character" probably means that the font you are using does not contain the particular glyph requested, so it was replaced with a "replacement glyph" -- this is nothing to do with SQLite3.