Russian characters

Jul 18, 2013 at 6:27 PM
Edited Jul 18, 2013 at 6:27 PM
Help please!!!

Which setting should be done to the text from the database with the Russian characters are displayed correctly after export to Excel? I use project by Mark Camilleri posted here:

Now Russian characters are displayed as "�1_���" for "Ф1_АПК"
Jul 19, 2013 at 9:39 AM

What version of Excel are you using?

You might take the latest version of the SQLite for Excel libraries directly, and just change one of the example macros to insert some Cyrillic, and see whether this works right.

If that doesn't help, write back and I can have a closer look. Maybe I'm calling one of the the Unicode conversion functions incorrectly.

Jul 19, 2013 at 10:25 AM
Edited Jul 19, 2013 at 10:36 AM

I am using Excel 2007.

An example of the procedure (and database) in attach based on SQLite for Excel libraries (file SQLiteForExcel.xls). My procedure "test" in the module Mytest. In the database the data is correct (see Test_DB.bmp), discharging through Ssqlite Administrator in Excel also correct.

Thank you!
Jul 19, 2013 at 9:38 PM

I looked at your data. The sqlite3 console app also does not display those string, nor does the LinqPad utility I use.

It seems the strings are not stored in UTF-8 format, perhaps in some code-page specific format. I suggest you first test by using SQLite for Excel to also insert the Cyrillic string data. If that works fine, you can try to figure what string format you are currently using, and try some kind of conversion.

I hope that helps.