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';
return split_and_decode(‘test+test+test',0,'%+');
}
which returns:
SQL> select test.test.testUrlDecode1 ();
testUrlDecode1
VARCHAR
_______________________________________________________________________________
test test test
1 Rows. -- 0 msec.
SQL>
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://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
On 1 Mar 2014, at 23:26, Hugh Williams <hwilli...@openlinksw.com> wrote:
> 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://twitter.com/OpenLink
> Google+ -- http://plus.google.com/100570109519069333827/
> Facebook -- http://www.facebook.com/OpenLinkSoftware
> Universal Data Access, Integration, and Management Technology Providers
>
> On 20 Feb 2014, at 12:29, Quentin <quent...@clearbluewater.com.au> wrote:
>
>> 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 result is different to conventional urldecoding done by javascript and
>> php which would generally return "test test test". The effect is to require
>> virtuoso specific work-arounds in external interfaces.
>>
>> --
>> Quentin | Clear Blue Water Pty Ltd
>> quent...@clearbluewater.com.au
>> ------------------------------------------------------------------------------
>> Managing the Performance of Cloud-Based Applications
>> Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
>> Read the Whitepaper.
>> http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk_______________________________________________
>> Virtuoso-users mailing list
>> Virtuoso-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
------------------------------------------------------------------------------
Subversion Kills Productivity. Get off Subversion & Make the Move to Perforce.
With Perforce, you get hassle-free workflows. Merge that actually works.
Faster operations. Version large binaries. Built-in WAN optimization and the
freedom to use Git, Perforce or both. Make the move to Perforce.
http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users