This is an extension of my "Binary Character" and PM/400 queries on
If I look at my test file via my JDBCR4 project, I find that JDBC gives
me a field length of 8 bytes for both BINCHAR and HEXADECIMAL fields,
but it gives me the actual field data for those fields as 16 hex digits.
Squirrel gives the field type for the BINCHAR field as "BINARY," as does
the field's entry in QSYS2/COLUMNS, which means I should be able to deal
with that, but as to the Hex field, I can't tell any difference between
it and the plain alphanumeric field in the SQL metadata.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.