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: Hans Bergsten
Date: October 28, 2008 11:59PM

Hi Peter,

Thanks for the reply, but unfortunately it isn't a solution, because the data types for the two columns in the mysql.proc table of interest are BLOB and LONGBLOB. Hence, the CHARACTER_SET_NAME column in INFORMATION_SCHEMA.COLUMNS have null values for these column.

The problem is that text data (SP code) is stored as binary data in the mysql.proc table, with no documentation on how the text is encoded (as far as I have been able to find).

Best Regards,
Hans

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.