In the last episode (Nov 29), David Garamond said:
> >It seems the string in CHAR/VARCHAR is stored as null-terminated ala
> >C. But why is record 3 rejected too?
>
> Ugh, never mind. I forgot about the automatic trailing blanks removal
> feature. Well, since trailing blanks are always removed, it means
> CHAR/VARCHAR could never store binary data then...
>
> Is there a 128-bit datatype planned? It would be handy to store
> GUID/UUID or IPv6 addresses.
You can use a TINYBLOB, which will consume 9 bytes (due to the length
byte), or you can use two BIGINTs. An interesting addition to mysql
would be a fixed-length BLOB field which can only hold N characters.
Might be more efficient than INTs for storing things like IP addresses,
checksums, or other values that happen to be N bytes but aren't really
numbers.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
