Bug #65944 increase max base for conv() function to 256

• Submitted: 18 Jul 2012 18:25
• Modified: 19 Jul 2012 6:16
• Reporter: Trey Raymond
• Status: Verified
• Category: MySQL Server: DML
• Severity: S4 (Feature request)
• Version: all (up to and incl 5.6)
• OS: Any
• CPU Architecture: Any
• Tags: conv base hex

[18 Jul 2012 18:25] Trey Raymond

Description:
Increasing the max base of the conv function to 256 makes manipulation of binary data much easier.  Workarounds exist for simple things like base-10 to binary like "select unhex(hex(base10))" but that is added steps...generally, it's impossible to do anything with high bases in a single function, and if you're not going straight to 256 - for example, some php configurations pass things like session_id in base 64, which is unsupported in any mysql before 5.6 - you need to write something more complex.  Conv is a great function, and would be much more useful if it simply handled the entire range of a byte.

How to repeat:
select conv() with a base >36

Suggested fix:
Increase the base limit from 36 to 256

[19 Jul 2012 6:16] Valeriy Kravchuk

Thank you for the feature request.