12 Feb
2003
12 Feb
'03
6:55 a.m.
Hi
On Tue, Feb 11, 2003 at 02:23:33PM -0500, Marc Delisle wrote:
currently in tbl_change, we display a file selector to
upload
into a field, when it's a BLOB or has the attribute Binary.
According to the MySQL doc:
"The BINARY attribute means that column values are sorted and
compared in case-sensitive fashion according to the ASCII order
of the machine where the MySQL server is running.
BINARY doesn't affect how the column is stored or retrieved."
If we take this to the letter, we should offer a file selector
for every field, because they all can have binary contents.
But I don't think it's a good idea!
However, I guess that most users choose the "binary" attribute
for a field to put some binary contents in it.
The bug 682346 occured first because his mysql.user file has
the binary attribute on some fields, like host.
So, do we still offer an upload choice for "binary" fields?
I thing for blob it would be enough... In fact I don't know for what
would I use small binary field but maybe somebody could need to put
there some data and there is no other way than uploading... Maybe it
would be better to put uploading stuff on separate page and add on
tbl_change (and maybe also on display_tbl where [binary] is being shown)
only link to that.
--
Regards
Michal Cihar
http://cihar.liten.cz