How to support non Unicode fields when using TUniConnection 10.2.1 to connect to SQLite database?
TUniConnection 10.2.1 When connecting to an SQLite database, because the field type of the table in the SQLite database is varchar (100) instead of Nvarchar (100), it is intuitively not a Unicode database,
My current problem is that when I compile a program in a Chinese Windows environment, it can read Chinese characters in SQLite (non Unicode, code page 936)
But I need to create an internationalized program, so I compiled the project using a pure English environment Delphi 12.2. The problem that occurred was that the data table could be read normally, but all non ASCII Chinese characters would be displayed as empty.
So I set the parameters
DMGoodsImport.UniConPOS.SpecificOptions.Values['UseUnicode'] :='False';
DMGoodsImport.UniConPOS.SpecificOptions.Values['ASCIIDataBase'] :='True';
At this point, the content can be displayed in the Chinese environment, or the result is garbled. I would like to know where to set it correctly?