Special characters, specifically ampersand, in JSON server-side population not displaying in grid?
Special characters, specifically ampersand, in JSON server-side population not displaying in grid?
mvelasquez
Posts: 17Questions: 0Answers: 0
I have an ampersand in my dataset.
Say my dataset is:
Row 1:
column 1: TEST&THIS
Row 2:
column 1: TEST & THIS
Row 3:
column 1: TEST& THIS
Row 4:
column 1: TEST &THIS
ACTUAL RESULTS:
TEST
TEST & THIS
TEST& THIS
TEST
In the first row, where there is no space before nor after the ampersand, the data comes back with everything from the ampersand and afterwards stripped off.
In the second row, where there is a space before AND after the ampersand, the data comes back perfectly.
In the third row, where there is a space AFTER the ampersand, the data comes back perfectly.
In the fourth row, where there is a space BEFORE but NOT AFTER the ampersand, the data comes back with everything from teh ampersand and afterwards stripped off.
It seems there MUST be a space after the ampersand, or everything from the ampersand on gets cut off in the UI.
However, at run time in the javascript, if I capture what row the user clicks, and grab the data from that column, it oddly comes back with the correct value, not truncated.
I would simply like the values to be displayed as they are. NO truncation at all.
I tried URL encoding and that didn't help. It actually displayed the URL encoding, not the standard value.
Say my dataset is:
Row 1:
column 1: TEST&THIS
Row 2:
column 1: TEST & THIS
Row 3:
column 1: TEST& THIS
Row 4:
column 1: TEST &THIS
ACTUAL RESULTS:
TEST
TEST & THIS
TEST& THIS
TEST
In the first row, where there is no space before nor after the ampersand, the data comes back with everything from the ampersand and afterwards stripped off.
In the second row, where there is a space before AND after the ampersand, the data comes back perfectly.
In the third row, where there is a space AFTER the ampersand, the data comes back perfectly.
In the fourth row, where there is a space BEFORE but NOT AFTER the ampersand, the data comes back with everything from teh ampersand and afterwards stripped off.
It seems there MUST be a space after the ampersand, or everything from the ampersand on gets cut off in the UI.
However, at run time in the javascript, if I capture what row the user clicks, and grab the data from that column, it oddly comes back with the correct value, not truncated.
I would simply like the values to be displayed as they are. NO truncation at all.
I tried URL encoding and that didn't help. It actually displayed the URL encoding, not the standard value.
This discussion has been closed.
Replies
Allan
I encoded it before sending it to the client.
Thx.