Oracle 11.2.0 vs Oracle 12.1.0 TWideStringField.Size

Forum related to Oracle Server

Moderators: gto, EgonHugeist, mdaems

marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1956
Joined: 17.01.2011, 14:17

Re: Oracle 11.2.0 vs Oracle 12.1.0 TWideStringField.Size

Post by marsupilami »

aehimself wrote: 28.11.2020, 20:57 Edit: @Jan, since the pull request for Fixed Delphi Linux64 target compilation was not yet closed, GitHub automatically added the MySQL field size fix to that one. Please import this commit too, before closing it now :)
Btw, is there an issue with the git synchronization / Jenkins? GitHub seems to be way before SubVersion and Jenkins is not available for me to check the task :(
I had to shut down the server last week because its room was getting a new roof. I have it running again now. SVN updates should be pushed to GIT again. Also Jenkins is available again.
Time is tight on me currently. I will merge your pull request during the next days.

Best regards,

Jan
User avatar
aehimself
Zeos Dev Team
Zeos Dev Team
Posts: 796
Joined: 18.11.2018, 17:37
Location: Hungary

Re: Oracle 11.2.0 vs Oracle 12.1.0 TWideStringField.Size

Post by aehimself »

marsupilami wrote: 01.12.2020, 13:38I had to shut down the server last week because its room was getting a new roof.
Tell me about it... Maybe this summer we will start a big renovation, meaning changing the ceiling of 3 rooms and a the complete roof of the house. It will be a nightmare.
marsupilami wrote: 01.12.2020, 13:38Time is tight on me currently. I will merge your pull request during the next days.
No worries, take your time. I was just wondering :)
Delphi 12.2, Zeos 8 from latest GIT snapshot
Using:
- MySQL server 8.0.18; libmysql.dll 8.0.40 x64 5.7.19 x68, libmariadb.dll 3.3.11
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.15
- MSSQL 2012, 2019; sybdb.dll FreeTDS_3102
- SQLite 3.47
User avatar
aehimself
Zeos Dev Team
Zeos Dev Team
Posts: 796
Joined: 18.11.2018, 17:37
Location: Hungary

Re: Oracle 11.2.0 vs Oracle 12.1.0 TWideStringField.Size

Post by aehimself »

Currently on Git

35a71fa0ba0fe729d46365433bc23f888fd6c3b6
Avoid Stack overflow in TryPCharToTimeStamp
egonhugeist on 12/5/2020, 6:48:04 AM

Most of the issues I found are gone, only Oracle and UTF16 truncation and text corruption remains.
Issue is present with oci.dll 19.8, 12.1; on Oracle server 11.2 and 12.1 also.
Delphi 12.2, Zeos 8 from latest GIT snapshot
Using:
- MySQL server 8.0.18; libmysql.dll 8.0.40 x64 5.7.19 x68, libmariadb.dll 3.3.11
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.15
- MSSQL 2012, 2019; sybdb.dll FreeTDS_3102
- SQLite 3.47
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1956
Joined: 17.01.2011, 14:17

Re: Oracle 11.2.0 vs Oracle 12.1.0 TWideStringField.Size

Post by marsupilami »

aehimself wrote: 06.12.2020, 09:25 35a71fa0ba0fe729d46365433bc23f888fd6c3b6
Avoid Stack overflow in TryPCharToTimeStamp
egonhugeist on 12/5/2020, 6:48:04 AM
That is Rev. 7151 - currently the newest revision.
User avatar
aehimself
Zeos Dev Team
Zeos Dev Team
Posts: 796
Joined: 18.11.2018, 17:37
Location: Hungary

Re: Oracle 11.2.0 vs Oracle 12.1.0 TWideStringField.Size

Post by aehimself »

I was a little bit excited when I saw this commit but unfortunately Oracle connections with UTF-16 encoding still throw the truncation error on fields with special characters :(
Delphi 12.2, Zeos 8 from latest GIT snapshot
Using:
- MySQL server 8.0.18; libmysql.dll 8.0.40 x64 5.7.19 x68, libmariadb.dll 3.3.11
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.15
- MSSQL 2012, 2019; sybdb.dll FreeTDS_3102
- SQLite 3.47
Post Reply