URL Encoding displaying as strange characters on serverside

[jers]

Hello everyone,

 

I am having an issue with a querystring being handed to PHP that I haven't been able to search a solution for.

 

given:

 

url = 'index.php?loadGraph=high_duration&exportXML=true&parameter='+globParameter+'&conditions='+filterCondStr;

getChartFromId('high_duration_chart').setDataURL(url);

 

 

 

Where filterCondStr = " AND task_name LIKE '%bas%'"

 

 

 

Gives me strange output for the value of $_GET['conditions'] on the PHP end, namely:

 

" AND task_name LIKE '

[jers]

I was able to solve my problem and I'll post my resolution here for posterity in case someone else runs into the problem.

 

I originally thought the issue stemmed from the fact that MSSQL has trouble with UTF-8... and by trouble I mean it can't handle it at all.

 

 

 

In the end, I replaced the %'s in my query with %25's via

 

string.replace(/%/, "%25")

 

And this seems to be working, I will update when I have done more testing.

[saptarshi]

Hello Jeremy,

 

 

 

Great that it is working now. And thank you for sharing your experience on the forum!