Zeoslib Portal

Hi, i found small problem with unicode when i create field longer then ~2000 chars like "VARCHAR(4000) CHARACTER SET UTF8 NOT NULL COLLATE UTF8" and store unicode string with like 3000 chars and query for that row, zeos will break encoding and shows it like in ascii not utf8 but when i ope...

its working, ty guys

When i try to query for data changed during another connection, zeos components will not return correct data steps to reproduce problem: #1, 1st connection calls query like SELECT DISTINCT(data) FROM test_table and result is 1, 2, 3, 4, 5 query:= TZReadOnlyQuery.Create(nil); query.Connection := ZCon...

EgonHugeist,

thx for looking at this, even 64K buffer is fine for me, couse i'll have probably just one such a big query...

from my point of view its a bug couse its i bit weird that you can have such a big field in db but you can't retrieve data in zeos, dynamic allocated buffers would be fine solution

Sorien , When changing ZGenericSqlToken.pas you mainly change the behaviour of the filter feature of the datasets. And those should respond to system settings. The database specific Tokenizers decide themselves if they use the generic (system dependent) behaviour or not. So maybe we better provide ...

I'll able to test it during a Monday i was thinking a bit about it and my and your solution seems to be wrong because we are trying to match it with system format not with proper database format which is wrong at second when i create query like INSERT INTO FOO VALUES('1.1.2012') tokenizer should ret...

it depends on TimeSeparator and DateSeparator settings Example for broken time token detection: 1. first check what is your TimeSeparator ZGenericSqlToken.pas TZGenericSQLQuoteState.NextToken line 187 if ReadChar = {$IFDEF WITH_FORMATSETTINGS}FormatSettings.{$ENDIF}TimeSeparator then mine is ':' 2. ...

it is bug in tokenizer, old or new don't know i'm using zeos lib like few weeks, im just curious why there is so primitive check for date, or why tokenizer tries to detect date field when its not used at any other place in library

codepage is set to UTF as whole DB just look at ZGenericSqlToken.pas TZGenericSQLQuoteState.NextToken, ttDate token detection is based on 2 "." which means that string like 'aa.bb.cc' will be detected wrong as date its not a proble until you will use some unicode chars TZAbstractStatement....

next huge bug is in tokenizer's date token detection when you set preparesql to true and system format to "d.M.rrrr" during processing query like "INSERT INTO FOO VALUES ('foo faaf faa ýľ .foo.')" tokenizer will return 'foo faaf faa ýľ .foo.' as ttDate (couse ttDate token detecti...

EgonHugeist wrote:Nope the issue was hopefully another one. The 'localhost' should be supported

Seems some '\\' where missed at beginning of the URL if your Localhost or Database wasn't set.

Rev. 1165. If that patch doesn't help. I'll commit yours.

Michael

thx, seems to be working

Hi, don't know if its exactly problem with your branch but i have problems to run database in embedded mode after switching to your branch, could you look at it pls... Edit: i've probably found it ZUrl.pas procedure TZURL.SetURL(const Value: string); var .. begin APrefix := ''; AProtocol := ''; AHos...