[Phpmyadmin-devel] about "binary" attribute

Marc Delisle delislma at CollegeSherbrooke.qc.ca
Tue Feb 11 11:24:05 CET 2003


Hi,

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?

Marc






More information about the Developers mailing list