I am using CartWeaver ColdFusion , and a mySQL database for an ecommerce store.
The product descriptions are entered through a simple text area form.
In the mySQL db, I can see the actual £ sign in the text field
But when displayed on the page, it converts to ?
I considered replacing all the pound signs in the database with £ , but that doesnt help me, since new products typed in will still be using the pound character ( not wanting to ask client to use £ every time! )
I tried a CF rereplace of the ? that is getting passed to the page, but it expects a regular expression after the ? so that doesnt work either!
What do I need to do, in the database, the entry form, or the display page ( or any of the above ) to get the £ to display as £ in the db output?
The page handles £ just fine in general, to see it, add anything to your cart.
but for some reason in this description field, it is a no go.