Re: [Virtuoso-users] splt_and_decode

2014-03-04 Thread Hugh Williams
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

Re: [Virtuoso-users] splt_and_decode

2014-03-01 Thread Hugh Williams
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

[Virtuoso-users] splt_and_decode

2014-02-20 Thread Quentin
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