Zeoslib Portal

Nice, even if I'm subscribed to a topic I'm not receiving notifications :( By UTF8 I meant AL32UTF8; because of your previous comment I already even forgot that the base UTF8 exists. As for a test case I'll try to create a similar table with similar data... as I mentioned it's a commercial database ...

marsupilami wrote:@Egonhugeist: I know it is a stupid question, but are we sure that we calculate the buffer size correctly?

Did we manage to get a reply on this one? I'm keeping the ClientCodePage on EE8MSWIN1250 for the time being but I'd feel a lot better just to set it to UTF8 and forget about this.

Hello, Filtering works just fine from 0 characters up. What I can see is that you are NOT ignoring the case, which means the value "Test" will not show up if you filter "like '%S%'". Try this: MyDataset.Filter := En_tete + ' like LOWER(''*' + String(TEdit(Sender).Text).ToLower + ...

Nice, I did not get a notification about a reply in the thread...

At home I'm using MySQL and at work we mainly use Oracle and a small fraction of MSSQL.
But I guess IF this will be implemented, it'll be implemented for all / most of the supported protocols, no?

Hello, You can try reading it to a stream and then converting it to TBytes: Var ms: TMemoryStream; tb: TBytes; Begin ms := TMemoryStream.Create; Try (ZQuery.FieldByName('TheField') As TBlobField).SaveToStream(ms); ms.Position := 0; SetLength(tb, ms.Size); ms.Read(tb, ms.Size); // Do something Finall...

With Oracle, UTF8 should be aliased to AL32UTF8 in Zeos. Because the Oracle UTF8 in reality is CESU-8... [...] What strikes me here: UTF8 can use up to 4 bytes per character and WIN1250 is a character set that only uses one byte per character. I did not know about this but this makes sense. What is...

So, managed to find something. Either it will be an Oracle bug or I don't understand Zeos's ClientCodePage well enough. Not only one test systems were affected, and those affected SELECT USERENV ('language') FROM DUAL returned "AMERICAN_AMERICA.EE8MSWIN1250". If in the connection I set Cli...

Hello, Since updating the Oracle client to 19.3.0 (wow, mine was seriously outdated...) did not fix the issue I installed Zeos 7.3 r5898 but the issue remains: [2019.09.05 10:59:33.967] Tab 0, TESTORACLE: Successfully connected to testoracle.internal in 966 millisecond(s). oracle 11.2.0, client vers...

Hello, Server is Oracle 11.2.0 and client library is 12.2.0. As for 7.3 I'm not sure, did not try it yet; to be honest I was waiting for the stable version before upgrading :) I'm not aware in how Zeos exactly does it magic in the background, but "FPlainDriver.AttrGet" suggests that the bu...

An other day, an other interesting error. I connected my application to an Oracle server with the client version number in the subject. When I'm trying to select data from a table, an ORA-01406 exception is thrown every second or so. My code is like the following: Procedure TForm1.ExecuteButtonClick...

Well, at least this answers why I found no article about this on the Internet :) I do understand that data transfer and components are on different layers and might not be able to change the others behavior, I was just hoping there's a parameter which I can set and will work similar to ZConnection's...

I am using a patched version of Zeos 7.2.4 (r5698, reports as 7.2.5-rc) with multiple databases (MySQL, Oracle and MsSQL mainly). I am writing a basic database browser application where you can enter a query and a DBGrid will display all the information. The data link is: TZConnection <- TZQuery <- ...

Please, please, please!!!! I had to re-write my DB management app to use datasources / DBGrids because of performance issues (manually building up a ListView with each row was painfully slow on 10-100k rows) but with this I lost the chance to show progress indicators. I was just looking for a way to...

I guess we can take the WLAN out of the question :) Today the same happened when I was using a wired connection. After the usual "Lost connection" a couple of access violation errors and sometimes my application just hangs endlessly, it does not even want to shut down by itself (it gets st...

Hello, I'm using Delphi 10.2 with Zeos 7.2.4-stable to connect to a MySQL 8.0.13 server using (the latest available, 8.0 is not yet included in the Windows installer) libmysql.dll version: 6.1.11. When I am debugging my application (connected to the DB via WLAN) I am greeted with the above two messa...