CODEWITHSUNDEEP
sqldatabasesqlite
George Liu
George Liu

Reputation: 3583

Unrecognized characters in DB Browser for SQLite

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

img1

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

img2

img3

img4

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

Upvotes: 0

Views: 3391

Answers (1)

rd_nielsen
rd_nielsen

Reputation: 2459

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.

Upvotes: 1

Related Questions