Subject | Re: blobs causes table fragmentation. |
---|---|
Author | Roman Rokytskyy |
Post date | 2004-10-05T10:49:32Z |
Pavel,
feature... but what looks better:
CREATE TABLE my_table {
bin_data BINARY(16000)
}
or
CREATE TABLE my_table {
bin_data VARCHAR(16000) CHARACTER SET OCTETS
}
Personally I like former case more than latter.
Roman
> AFAIK you can do that already without new datatype, just use VARCHARYes, you can and this combination I had in mind when I proposed that
> with character set OCTETS.
feature... but what looks better:
CREATE TABLE my_table {
bin_data BINARY(16000)
}
or
CREATE TABLE my_table {
bin_data VARCHAR(16000) CHARACTER SET OCTETS
}
Personally I like former case more than latter.
Roman