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
Copyright © 2024 Thunderstone Software LLC. All rights reserved.