euro symbol issue

[puttakanda]

We are getting serious issues with EURO symbol. We are entering Euro symbol from a html form and ending up with € when trying to query from thuderstone and display it.
I have checked this, even using tsql and ending up with Γé¼ as seen on command prompt.
Please advise..

[mark]

Are you using the variable from the form directly in your insert statement? Or are you performing some processing or passing it between programs first?

If you're using it directly the browser must be encoding the the data before sending it. You can decode it with the following before inserting it.
<fmt "%!H" $myvar><$myvar=$ret>
(if your texis is newer than sep 13 2000 http://www.thunderstone.com/site/vortexman/node89.html )

You can test to see exactly what the browser is sending with something like this:
<write /tmp/debug.out>
<fmt "%s" $myvar>
</write>
Then look at the file /tmp/debug.out to see exactly what came in.