|
Posted by Alexander Kuznetsov on 11/11/84 11:52
Ken,
If you want both 4 byte storage and 0 to 4294967295 range, you could
store an int stored_value = (your_value - 2147483648) and have a
computed column (cast(stored_value as bigint) + 2147483648). Not sure
if saving 4 bytes of storage is worth the effort in your case, but
sometimes it definitely is worth trying.
Good luck!
Navigation:
[Reply to this message]
|