Really, the built-in MSEgui support of SQLite is brilliant :) Highly recommended !
2011/10/19, Martin Schreiber <mse00...@gmail.com>: > On Wednesday 19 October 2011 12.27:05 Christian Nobel wrote: >> >> Ahhh, bummer, found the problem. >> >> Indirectly you gave me the answer. >> >> There are no limitations in SQLite on the length of a Varchar, so by >> using the SQLite manager, it is possible to fill the field with a long >> text. >> >> But the problem appears to be the interpretation of the field by Zeos >> (and probably other db libraries) as the field is truncated. >> >> Changing the field to text instead of varchar changes the behaviour of >> Zeos, as the field now is seen as a memo field. >> > Or as suggested, use MSEgui DB components. They don't have a VARCHAR field > length limitation. The performance of a memo field (=BLOB) is not so good. > It > is also possible to map SQlite text fields to VARCHAR(0) -> unlimited string > field. > > Martin > _______________________________________________ > MSEide-MSEgui-talk mailing list > MSEide-MSEgui-talk@lists.berlios.de > https://lists.berlios.de/mailman/listinfo/mseide-msegui-talk > _______________________________________________ MSEide-MSEgui-talk mailing list MSEide-MSEgui-talk@lists.berlios.de https://lists.berlios.de/mailman/listinfo/mseide-msegui-talk