Re: Difference between Blob and varchar binary

2005-08-03 Thread Jigal van Hemert
Gleb Paharenko wrote: In my opinion, one of the causes of the problem can be the processing of trailing spaces in varbinary fields. See: http://dev.mysql.com/doc/mysql/en/binary-varbinary.html William R. Mussatto [EMAIL PROTECTED] wrote: I was storing some 8 bit information in a varchar

Difference between Blob and varchar binary

2005-08-02 Thread William R. Mussatto
I was storing some 8 bit information in a varchar binary field (encrypted stuff) and I think its getting corrupted. I thought they were (except for size) interchangable? I'm running debian GNU Linux and haven't moved to sarge so I'm still on 3.23.x but will be moving shortly. --- William R.

Re: Difference between Blob and varchar binary

2005-08-02 Thread Gleb Paharenko
Hello. In my opinion, one of the causes of the problem can be the processing of trailing spaces in varbinary fields. See: http://dev.mysql.com/doc/mysql/en/binary-varbinary.html William R. Mussatto [EMAIL PROTECTED] wrote: I was storing some 8 bit information in a varchar binary

Re: Difference between Blob and varchar binary

2005-08-02 Thread William R. Mussatto
Gleb Paharenko said: Hello. In my opinion, one of the causes of the problem can be the processing of trailing spaces in varbinary fields. See: http://dev.mysql.com/doc/mysql/en/binary-varbinary.html Thanks, you may be right since the results are too short. William R. Mussatto [EMAIL