Mark,
----- Original Message ----- From: "Mark Maunder" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Friday, December 03, 2004 10:52 PM
Subject: Re: if last binary byte is space (ascii 32) mysql drops it
So what you're saying is that BINARY isn't binary because it chomps spaces off the end, thereby corrupting the binary data. Sounds like a bug. Should I report it?
it is in the TODO to implement a real VARCHAR to MySQL. That fix may also fix the annoying problem that MySQL removes trailing characters ASCII(32) from the end of all strings, including a BINARY string. It is really counterintuitive, I agree.
It does not hurt to report this as a bug at bugs.mysql.com. It could speed up the fixing of this problem.
On Fri, 2004-12-03 at 12:30, Paul DuBois wrote:I agree about using the TINYBLOB to avoid trailing space truncation, but BINARY and VARBINARY are MySQL data types now.
http://dev.mysql.com/doc/mysql/en/BINARY_VARBINARY.html
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php
Order MySQL technical support from https://order.mysql.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
