Hi Jan,
Of course you can test on Linux, maybe right away in the 21c Express Edition.
In fact, I hardly use Oracle, and my attention to the problem was that I came across it during testing.
I dealt with it temporarily by using the table names explicitly.
One more thing.
Note that the server can be on Linux and the client can be on Linux but also on Windows
Michał
Use TZMetaData to identify what type of field
Re: Use TZMetaData to identify what type of field
You da man, Jan. Yep, works like a charm, finally could get rid of my dummy query :)marsupilami wrote: ↑30.01.2022, 12:38I changed the driver to return the CHAR_LENGTH value for string types in the COLUMN_SIZE column and to only use DATA_LENGTH for the CHAR_OCTETS_LENGTH column.
Yes, don't ever roll back this commit, please! :)
With all due seriousness, though...
This information is coming from the database, not the IDE. If I need the buffer size and I know all drivers return it as ANSI... I'll have no issues having a magic number multiplier hardcoded.marsupilami wrote: ↑30.01.2022, 12:38The current calculation only makes sense for IDEs that use ANSISTRING and not UNICODESTRING as their default string type...
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
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
-
- Platinum Boarder
- Posts: 1956
- Joined: 17.01.2011, 14:17
Re: Use TZMetaData to identify what type of field
That is the problem - they don't give consistent results currentlyaehimself wrote: ↑30.01.2022, 22:54This information is coming from the database, not the IDE. If I need the buffer size and I know all drivers return it as ANSI... I'll have no issues having a magic number multiplier hardcoded.marsupilami wrote: ↑30.01.2022, 12:38The current calculation only makes sense for IDEs that use ANSISTRING and not UNICODESTRING as their default string type...