Using Special Characters

FusionCharts Querystring allows us to use special characters in our charts. To use characters other than alphabets and numerical digits and , . - +  we must remain a bit cautious. Some characters like ;(or user-defined delimiter), =, [, ], & ,#,must never be included as value of parameters or data or anywhere other than their syntactical use.


Hence, the special characters must be used in encoded form. Let's see how we can add % sign as Number suffix. Here, instead of % we give its encoded form. It is %25, technically the URL Encoded form of %. However, in FileMaker for Windows or in FusionCharts Querystring Validator/URL Validator, we would need to use the Double URL Encoded form, which is %2525, i.e. we would need to replace all the % signs again with %25.

 
In FileMaker for Mac
?v=3
&chart=[chartType=Column2D;chartWidth=350;chartHeight=240]
&chartParams=[numberSuffix=%25]
&labels=Jeff;Mary;Shirley
&data=120;198;211
 
In FileMaker for Windows or in Querystring/URL Validator
?v=3
&chart=[chartType=Column2D;chartWidth=350;chartHeight=240]
&chartParams=[numberSuffix=%2525]
&labels=Jeff;Mary;Shirley
&data=120;198;211
 
Please note that the special characters are twice encoded in FileMaker for Windows. Hence, we would separately list the encoded form that is to be used in FileMaker for mac and FusinCharts for Windows or FusionCharts Querystring/URL Validator.
 
we can add '%' as Number Suffix by specifying numberSuffix=%25.
 
 
Similary, to use € as our currency we must set the number prefix thus:
 
In FileMaker for Mac
?v=3
&chart=[chartType=Column2D;chartWidth=350;chartHeight=240]
&chartParams=[numberPrefix=%E2%82%AC]
&labels=Jeff;Mary;Shirley
&data=120;198;211
 
In FileMaker for Windows or in Querystring/URL Validator
?v=3
&chart=[chartType=Column2D;chartWidth=350;chartHeight=240]
&chartParams=[numberPrefix=%25E2%2582%25AC]
&labels=Jeff;Mary;Shirley
&data=120;198;211
 
Take a look at the output:
 
Note that FusionCharts Library (FusionCharts Library.fp7) provides you with scripts that can encode special characters in FusionCharts Querystring format. Please refer to FusionCharts Library section for more details on scripts - EscapeAllSpecialCharacters & EscapePercentAndForwardSlashCharacters.
 
Here is a list of Special Characters and their corresponding encoded forms for reference. We need to replace our desired special character with the corresponding encoded form in FCQS.
 

Character

Encoded Form
( Mac)

Encoded Form
(Windows)
¢ %a2 %25a2
£ %a3 %25a3
¥ %a5 %25a5

#

 %23

%2523

[

 %5b

%255b

&

 %26

%2526

?

 %3f

%253f

;

 %3b

%253b

> 

 %26gt%3b

%2526gt%253b
/ %2f %252f
 

Character

 Encoded Form
(Mac)

Encoded Form
(Windows)
€ %E2%82%AC %25e2%2582%25ac
₣ %e2%82%a3 %25e2%2582%25a3
% %25 %2525

|

 %7c

%257c

]

 %5d

%255d

@

%40

%2540

+

 %2b

%252b

=

 %3d

%253d

<

 %26lt%3b

%2526lt%253b
\ %5c %255c
" %22 %2522