Plus sign in details field are replaced by spaces

Scheduler Javascript
#1

Hello,

like said in the title, when i create an event, i use the plus sign “+” in the details field, it is saved in the db as a space.
I tried to edit it in onEventSave, as I can see the data.details still has the plus sign at this time, but it does not work. The data is saved with spaces.
I can’t find any solution here, any idea ?

#2

Which code you are using for data saving.
Default solution, with dataProcessor on a client-side doesn’t have such issue.

#3

Hi, thanks for your reply.
i use dataProcessor, here is my code:

index.php:
var dp = new dataProcessor(“data/update_events.php”);
dp.init(scheduler);
dp.enableUTFencoding(false);

data/update_events.php:
function add_row(){
mysql_query(“SET NAMES ‘utf8’”);
$sql = “INSERT INTO calmwd_events(start_date,end_date,text,details,section_id,type,create_by,num_inter,id_client,urgent,na,fait,pieces,rec_type,event_length,event_pid,lat,lng,date_add,tel)
VALUES (’”.$_GET[“start_date”]."’,
‘".$_GET[“end_date”]."’,
‘".$_GET[“text”]."’,
‘".$_GET[“details”]."’,
‘".$_GET[“section_id”]."’,
‘".$_GET[“type”]."’,
‘".$_GET[“create_by”]."’,
‘".$_GET[“num_inter”]."’,
‘".$_GET[“id_client”]."’,
‘".$_GET[“urgent”]."’,
‘".$_GET[“na”]."’,
‘".$_GET[“fait”]."’,
‘".$_GET[“pieces”]."’,
‘".$_GET[“rec_type”]."’,
‘".$_GET[“event_length”]."’,
‘".$_GET[“event_pid”]."’,
‘".$_GET[“lat”]."’,
‘".$_GET[“lng”]."’,
‘".date(“Y-m-d H:i”)."’,
‘".$_GET[“tel”]."’)";
$res = mysql_query($sql);
$newId = mysql_insert_id();
return “insert”;
}

#4

You could set dp.enableUTFencoding(true) instead of dp.enableUTFencoding(false).
In this case “encodeURIComponent” function will be used for encoding instead of “escape”.

#5

you are right, it is working fine now.
Thanks for your help !