Hi Stu,
There are a few things in play here.
That's a unicode character. chr(8217) if you're interested.
If your app is going to accept unicode characters (and no reason why it shouldn't) then make sure your Charset (Webserver / Advanced tab) is set to
'utf-8'
At the moment there is no Clarion unicode string type. With any luck that's coming, but it's not here yet. So you now have 2 choices;
Either save the string as unicode, without any transformation to Ascii or convert the character to something in the Ascii range before saving.
Storing as utf-8 can cause problems elsewhere - especially if you use the string on a report, or inspect the table with external tools etc.
Converting to ASCII is fine (set "Store as" to ASCII on the Webserver Advanced tab).
You will need either build 8.05, or 7.39, or you need to add the following 4 lines to NetWeb.Clw at the top of the NetWebServerWorker.UtfToAscii method;
utfmap[8216] = 39 ! open single quote, changed to '
utfmap[8217] = 39 ! close single quote, changed to '
utfmap[8220] = 34 ! open double quote, changed to "
utfmap[8221] = 34 ! close double quote, changed to "
This takes care of the single and double quotes - but of course there are many zillions of unicode chars out there, so this issue could arise again with another character. In the long run a Ustring data type will be a good thing (so encourage SoftVelocity to expedite that.)