[RESOLVED] RC6 SQLite - how to store/read a LONG-Array?

[Schmidt]

So, how to store a UTF-16 string in TEXT field correctly, if at all it can be done?

Rs("MyTextField") = MyUTF16_VBString

That's how you store Unicode-Text via the Rs-interface of the SQLite-wrapper.

It does not matter, whether the SQLite-DB was switched to utf16- or utf8- Text-storagemode...

At VB-Level, you will get back the exact same String, you've put into the DB-Text-Field.
(any conversion between utf-8 and uft-16 is completely lossless regarding string-content).

Cannot see, how ByteArrays or Blobs come into the game, when it's only about String-storage.

Olaf