Difference between CHAR(n) FOR BIT DATA and BINARY(n)?
2
votes
1
answer
966
views
I think I have seen somewhere that there is some sort of semantic difference between
CHAR(n) FOR BIT DATA
and BINARY(n)
, but I'm unable to locate where it was. Any pointers?
I'm asking because I have loads of columns defined as CHAR(16) FOR BIT DATA
from before BINARY(16)
existed, and thinking about gradually migrate them to BINARY(16). I'm curious whether there are any circomstances where migrating one side of a f.k. relationship before the other will cause problems.
Asked by Lennart - Slava Ukraini
(23862 rep)
Nov 4, 2022, 10:01 PM
Last activity: Nov 6, 2022, 08:02 AM
Last activity: Nov 6, 2022, 08:02 AM