[Phpmyadmin-devel] about "binary" attribute

Michal Cihar nijel at users.sourceforge.net
Wed Feb 12 03:55:05 CET 2003


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.

	Michal Cihar

More information about the Developers mailing list