CRv9
DB2
IBM DB2 ODBC Driver
We’ve run into some weirdness when doing some tests in Crystal v9 on a![[machinegun]](/data/assets/smilies/machinegun.gif "[machinegun] [machinegun]")
DB2 database using datatype VARGRAPHIC and I was curious as to if any of you have seen this behavior before. Upon viewing the table in db2 we saw that in the database field shows VARGRAPHIC(512) but when viewing the field in crystal it showed type: STRING, length: 1024. I’m being told that this is crystal showing the byte size not character size. I’ve personally never seen this anomaly but that doesn’t mean that it’s not common. For our ODBC driver, we are using: IBM DB2 ODBC Driver. Can any one shine any light on our issue?
VARGRAPHIC types are varying-length strings of up to 16 336 double-byte characters
Is the length being shown when browsing that number of characters or the number of bytes?
Thanks,
Jacque
DB2
IBM DB2 ODBC Driver
We’ve run into some weirdness when doing some tests in Crystal v9 on a
DB2 database using datatype VARGRAPHIC and I was curious as to if any of you have seen this behavior before. Upon viewing the table in db2 we saw that in the database field shows VARGRAPHIC(512) but when viewing the field in crystal it showed type: STRING, length: 1024. I’m being told that this is crystal showing the byte size not character size. I’ve personally never seen this anomaly but that doesn’t mean that it’s not common. For our ODBC driver, we are using: IBM DB2 ODBC Driver. Can any one shine any light on our issue?VARGRAPHIC types are varying-length strings of up to 16 336 double-byte characters
Is the length being shown when browsing that number of characters or the number of bytes?
Thanks,
Jacque