Bug #4314 Doc Bug: Binary *not* case sensitive

• Submitted: 28 Jun 2004 19:47
• Modified: 28 Jun 2004 20:09
• Reporter: Erik
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 4.x
• OS: n/a
• CPU Architecture: Any

[28 Jun 2004 19:47] Erik

Description:
I am pretty sure this is wrong.  on page 
http://dev.mysql.com/doc/mysql/en/BLOB.html

it says
"Sorting and comparison for BLOB values is *not* case sensitive"

A BLOB value by definition is a binary value.  A Binary compare *is* going to be case sensitive.

If BLOBs are being compared as Text then that should be made Very Very clear in the docs.

If what you are actually trying to say is that character collation sequence is ignored; then you need to say that differently, the current wording is too confusing.

How to repeat:
read page http://dev.mysql.com/doc/mysql/en/BLOB.html
look for the phrase
"Sorting and comparison for BLOB values is not case sensitive"

Suggested fix:
"Sorting and comparison for BLOB values is case sensitive"

[28 Jun 2004 20:09] Paul DuBois

Thank you for your bug report. This issue has been addressed in the
documentation. The updated documentation will appear on our website
shortly, and will be included in the next release of the relevant
product(s).