Devart Forums

hi:
i met a problem in my project. i use the unidac connect the sqlite database. the problem is cant't show the chinese data in the unidac components.
the uniconnection options-useunicode is true. the sqlite pragma encoding is utf8. how can i do that can show the right chinese data.
sorry for my terrible english.

Hello

If you set the UseUnicode specific option to True then text will be read from a SQLite database in the UTF16 encoding. If you want to get this text in the UTF8 encoding then you should get the text in the UTF16 encoding (AsWideString) and convert it to the UTF8 encoding (for example you can use WinApi function WideCharToMultiByte).

Sorry for what may seem a dumb question but how do you turn on the UseUnicode option for SQLite

hello,

You can set the UseUnicode option like

UniConnection1.SpecificOptions.Values['UseUnicode']:='TRUE';

or in the Object inspector open the SpecificOptions property and in the Options tab set it

Wonderful, this has fixed this problem for me