Problem with accented characters with SQLite 2 database on Windows

[ZaneCEO]

I'm experiencing a problem with various characters such as àèéìòù (italian keyboard) and the celsius degree ° . Such chars are shown as <?>, see the following image:

This is an old SQLite 2 DB accessed via an old Visual Basic 6 application.

The same data are OK when shown in the VB application itself or in an old SQLite manager program such as DBManager (the one I'm trying to move away from).

I uploaded a portion of the interested DB here:

https://1drv.ms/u/s!AsVM7b9VOo1VwX2oifeR6Sd9UvL1

Opening it should suffice to reproduce the problem.

I'm experiencing this issue with Windows 10 x64 and SQLiteStudio 3.2.1

[pawelsalawa]

I'm guessing that the problem is SQLite library used by VB6 vs library used by SQLiteStudio. The difference is in compiled-in character encoding. Unfortunately in SQLite2 this encoding is preselected at compilation stage and it cannot be changed in runtime.

I believe SQLiteStudio uses SQLite2 with UTF-8 encoding, whereas VB6 is probably using ISO8859-1.

In future versions of SQLiteStudio there could be 2 SQLite2 plugins - one for each encoding. This way the problem would be solved, but it needs extra work, so... some day in future.

[ZaneCEO]

Thanks for your explanation! I'll remain subscribed to this issue to know when it's done.