Hi, We can decalre a varchar field as BINARY if we need case sensitive storage of field values. Regards, Ravi --- ryc <[EMAIL PROTECTED]> wrote: > Varchar fields are not binary, blobs are. > > ryan > > > Hi & Help! > > > > I would like to store some short binary data > (encrypted). I used a > > varchar(24) binary field for this. > > But it seems that MySQL cuts white-spaces from the > end when storing the > > data in the table. When the encrypted string now > has a white-space at > > end, MySQL will cut it and this will result in a > wrong decryption (next > > time when the string is read and decrypted). > > > > When using TinyBlob instead of varchar binary, all > works fine. Is this a > > "feature" of varchar binary? In my opinion, binary > data shouldn't be > > trimmed! > > > > Please answer me via mail as I don't receive the > mailing list. > > Thanks for your support! > > > > ... tobias wiersch > > > > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list > archive) > > > > To request this thread, e-mail > <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > ____________________________________________________________ Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Varchar binary field auto-trimmed??
VVM Ravikumar Sarma Chengalvala Tue, 15 May 2001 11:31:11 -0700
- Varchar binary field auto-trimmed?? Swift
- Re: Varchar binary field auto-trimmed... ryc
- RE: Varchar binary field auto-tri... VVM Ravikumar Sarma Chengalvala
- RE: Varchar binary field auto-trimmed... Robert Henkel