? Sterling Symbol

[pwizzard]

I've just started using mySQL database as opposed to Access, I have a text
field where it is more than likely the user will enter a ? (Sterling) symbol,
uploading to Access the character displays correctly however to mySQL a (box)
is returned. Any ideas how to get the mySQL working correctly.

[bigbrain28]

I am running MSSQL and just tested this, by typing ALT+0163 into my Windows PC
to create the ? symbol (as it is not a keyboard key here in the US) And had it
insert the data into a nvarchar field in the table and it redisplayed fine. I
guess the question is "what is the field type you are sending the users data
to?" If its straight up text, it should except any acsii char, if its money or
integer/numeric, it's probably not liking the non-numeric ? sign. If the field
is always going to be a Sterling value, I'd say ignore the symbol and display
it on out put with the LSCurrencyFormat tag, if its going to be different
currency types, add another field to designate locale so LSCurrency can use it
to display the proper symbol on output.

[QCH]

Hi,
i also facing the same problem - my customer want the symbol display in the
report (CF Report Builder - PDF).

what i tries is the MYSQL ("??" stored in database ) and the CFM ("?"
display in CFM) can stored and display, good, but when come to report (CF
Report Builder - PDF format) this symbol cannot display :(


Thank you.

Regards,
QCH

[BKBK]

The Unicode for the Pound-sterling symbol is u00A3 or 0x00A3, which has a
decimal value of 163. Hence, store the symbol in the database as chr(163). For
example,

<cfquery>
insert into myTable (symbol, amount)
values ('#chr(163)#',29.99)
</cfquery>