byte / char Conversion As-is Without Hexifying - Caveat
| Caveat: In version 7 and later, converting byte values to char (and vice versa) copies the data as-is (stopping at a null byte), without converting to (or from) hexadecimal. |
This makes it easier to manipulate and view varbyte table
columns that may contain polymorphic but often-textual data, and
maintains consistency with Vortex, which never implicitly converts to
or from hexadecimal when dealing with byte data. To convert
data to hex or back in version 7, use the new hextobin() and
bintohex() SQL functions. This behavior change is rolled back
if <vxcp compatibilityversion> is set to 6.
Copyright © Thunderstone Software Last updated: Apr 15 2024