Zeoslib Portal

Hi, we just stumpled across a little oddity when executing a rather large SELECT statement (lots of joins etc.). The resulting rows exceeded the hardcoded limit of 32kb per row in Zeos. This limit is defined in ZDbcCache.pas by defining the Columns as TByteArray (TByteArray is defined as array[0..32...

Is it intended that TZAbstractRODataset.SetStatementParams() does not take stUnicodeString into account?

I am currently hunting down several bottle necks regarding unicode support.
I will post further stuff I find about unicode related things in this thread.

[...] for i:=0 to q.RecordCount-1 do begin [...] q.RecNo:=i+2; end; end; finally q.Close; FreeAndNil(q); end; YazdirmaBaslat; Sleep(1000); end; finally fConnection.Disconnect; FreeAndNil(fConnection); FreeAndNil(plist); end; end; [...] Are you sure that this is correct: q.RecNo:=i+2; IMO you are ru...

According to the code (ZDbcSqLiteResultSet.pas) it seems impossible to make a difference...
which SQLite.dll do you use?

Well, to be honest, this is neither nor. :) SQlite simply stores Data native as either UTF8 or UTF16 (defaulting to UTF8). What I did was "inventing" new fieldtypes (WIDETEXT and WIDECHAR) for knowing what the real data in the field is. So this is really an ugly hack breaking with SQL stan...

The problem you describe relies on the fact that SQLite does not report a fieldtype when you do "SELECT ... AS". Zeos defaults to use stString as fieldtype when it encounters an unknown fieldtype (in this case it is simply an empty string). There is no way of knowing the fieldtype without ...

Hi, my first Zeos Hack. This hack allows the use of UTF8 reading from queries and tables in SQLite. There is a drawback nontheless as one will be forced to use "WIDECHAR(XXX)" as datatype in the SQLite DB. This is possible, as SQLite always considers a fieldtype to be text whenever the Key...