You are only providing one of two required values for the function. Additionally, make sure the column you wish to store the value in is defined as a blob.
The pass_str MotW3 mentioned just represents the password that you want to associate with the encoding. You'll have to use the same password in your DECODE statment.
Now for a slight tangent, being an Oracle SQL person, the DECODE function means something different to me. In Oracle, it can be used to remap values, sort of like a simple case statement (or like an expanded IFNULL function). Is there an analog to this in MySQL?
In Oracle, it can be used to remap values, sort of like a simple case statement (or like an expanded IFNULL function). Is there an analog to this in MySQL?
Well, i don't know exactly. I'm not sure if there is that kind of function in MySQL, which is like expanded IFNULL .