Unrecognized characters in DB Browser for SQLite

Question

I opened up a Northwind database (northwind.sqlite3) using DB Browser for SQLite (Version 3.9.1).

For some product names, I couldn't get the right names displayed no matter what I did, including:

I changed new line characters options
I changed Preferences options
I checked the outputted csv using Excel and Notepad with different encoding

Still couldn't figure out how to properly show the characters...Any help is appreciated.

What is the output of SELECT hex(ProductName) FROM Products WHERE ProductID = 23? — CL.
– CL., Commented Jun 26, 2017 at 14:50

rd_nielsen · Accepted Answer · 2017-06-26 15:01:06Z

1

The problem may be either that data have been added to the database in an incompatible encoding (e.g., pasting data from Microsoft products into a UTF-8 database can do this) or that the DB Browser isn't displaying the data in the correct encoding. To fix the former problem you may have to edit the data, or possibly change the database encoding. You can't change the encoding of a SQLite database on the fly, so you would have to export the data and import them into a new database with the encoding that is actually used. If it's just a DB Browser display issue, right-click on the table header and choose the option to change the display encoding.

answered Jun 26, 2017 at 15:01

rd_nielsen

2,4592 gold badges14 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

George Liu Over a year ago

Thanks for the response @rd_nielsen! I'm trying to change the encoding by right clicking on the header ProductName. Do you have any suggestions for the encoding I should use?

rd_nielsen Over a year ago

cp1252 at a guess, especially if you're on Windows or the data came from Windows.

Collectives™ on Stack Overflow

Unrecognized characters in DB Browser for SQLite

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related