Pound Sterling Problem

[smnbin]

Hello,

I have some Coldfusion code that receives input from a textarea form field and
stores it in a MySQL database "text" field. A separate Coldfusion script
extracts the text from the database and displays it on a web page.

Everything seems to be working okay except when the pound sterling (?) symbol
is submitted as part of the form input. The symbol is entered correctly into
the database. However, when the symbol is extracted from the database and
displayed on the web page it appears as a question mark (?) symbol.

What could be causing this?

Many thanks in advance.

Simon :confused;

[smnbin]

Please note that this is happening for other special characters as well (i.e. ½). Most special characters are appearing okay though.

[philh]

Hi smnbin,

The "usual" standard HTML code for the pound sign is £

You can probably replace the char() value in your text field with that string.

HTH,