sql, table
I'm storing a SHA1 checksum as varchar(20) binary in my application.
After running a test, it seems MySQL will strip trailing spaces from a
varchar column, even if it is binary! That means if the last character
of my SHA1 checksum happens to be a space, MySQL will corrupt it.
What
On Sun 2002-12-29 at 05:28:57 -0500, [EMAIL PROTECTED] wrote:
sql, table
I'm storing a SHA1 checksum as varchar(20) binary in my application.
After running a test, it seems MySQL will strip trailing spaces from a
varchar column, even if it is binary!
Yes, the BINARY keyword only
PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, December 29, 2002 12:34 PM
Subject: Re: Storing a SHA1 checksum
On Sun 2002-12-29 at 05:28:57 -0500, [EMAIL PROTECTED] wrote:
sql, table
I'm storing a SHA1 checksum as varchar(20) binary in my
application.
After running a test, it seems MySQL
I would try storing the SHA1() result as a hexadecimal string.
Adolfo
-Original Message-
From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002 7:35 AM
To: Philip Mak
Cc: [EMAIL PROTECTED]
Subject: Re: Storing a SHA1 checksum
On Sun 2002-12-29
At 5:28 -0500 12/29/02, Philip Mak wrote:
sql, table
I'm storing a SHA1 checksum as varchar(20) binary in my application.
Other people have addressed other aspects of your message, but I'm
curious why you're using a VARCHAR(20), when SHA1() returns a 40-byte
string.
After running a test
On Sun, Dec 29, 2002 at 11:09:47PM -0600, Paul DuBois wrote:
At 5:28 -0500 12/29/02, Philip Mak wrote:
sql, table
I'm storing a SHA1 checksum as varchar(20) binary in my application.
Other people have addressed other aspects of your message, but I'm
curious why you're using a VARCHAR(20
At 0:14 -0500 12/30/02, Philip Mak wrote:
On Sun, Dec 29, 2002 at 11:09:47PM -0600, Paul DuBois wrote:
At 5:28 -0500 12/29/02, Philip Mak wrote:
sql, table
I'm storing a SHA1 checksum as varchar(20) binary in my application.
Other people have addressed other aspects of your message