SQLite db file lost table after read and write as text file.

[NTT]

Billko,

I tried that and as I said I cannot load the db file into SQLite. It returns error say Could not add database .....

[billko]

---

@NTT wrote:

Billko,

I tried that and as I said I cannot load the db file into SQLite. It returns error say Could not add database .....

---

Sorry about that.  I got mixed up with who was saying what, and you definitely did try it.

[rolfk]

Binary is anything not text to me. That includes a byte stream, aka an array of 8 bit integers, which technically can be also a LabVIEW string, unfortunately!

It is really unfortunate that the LabVIEW developers back in those days didn't make that distinction clearer. It would have solved many troubles including easier implementation of Unicode support in current LabVIEW versions. But back in the late eighties of last century the idea that there could be something like Unicode that would be feasible for anything but expensive mainframes was kind of hard to believe!  It was only 10 years later when the designers of Java made a clear distinction between byte arrays and text and also consequently implemented everything with these two very distinctive modes.