MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

Re: What encoding is used for the text in the mysql.proc table param_list and body columns?
Posted by: Peter Brawley
Date: October 29, 2008 08:21AM

From the manual:

BLOB columns are treated as binary strings (byte strings). TEXT columns are treated as non-binary strings (character strings). BLOB columns have no character set, and sorting and comparison are based on the numeric values of the bytes in column values. TEXT columns have a character set, and values are sorted and compared based on the collation of the character set.

PB
http://www.artfulsoftware.com

Navigate: Previous Message• Next Message
Options: Reply• Quote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.