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