Hi Quentin,
Development indicate the correct escape chars are needed for this to work which
are :
split_and_decode(‘test+test+test',0,'%+');
So the following procedure:
create procedure test.test.testUrlDecode1 ( ) returns VARCHAR
{
declare test VARCHAR;
test :='test+test+test';
re
Hi Quinten,
I am checking this with development ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http
I'm not sure whether this is an error but percent-decoding isn't getting +
encoded spaces.
create procedure test.test.testUrlDecode ( ) returns VARCHAR
{
declare test VARCHAR;
test :='test+test+test';
return split_and_decode(test,0,'%');
}
Query result:testUrlDecode
VARCHAR test+test+test
The