Form selection with apostrophe not captured in token

Anonymous
Not applicable

Form selection with apostrophe not captured in token

I have a form with a selection field 'country'.

One of my drop-down values is 'People's Republic of China'. Everything displays fine. 

In the token, this formats as 'People', and the rest is truncated. 

A bug or fixable? Values in list are separated by ','. 
Tags (1)
2 REPLIES 2
Anonymous
Not applicable

Re: Form selection with apostrophe not captured in token

Not exactly a bug. It is more the nature of delimiters and separators. 
You will find identical results in most web applications.
The SQL standard specifies that single-quotes in strings are escaped by putting two single quotes in a row.
 
 
Anonymous
Not applicable

Re: Form selection with apostrophe not captured in token

I recently encountered the same thing.   I now just leave the apostrophe out to stop the text from getting truncated.