I'm Storing Weird (�) Characters

[Gary Williams]

Hi All,

In a couple of fields in an access database, I'm storing prices with a GBP (£) sign before the numerials, ie, £450.00, instead of just the number 450.00

Usually this is fine, but occasionally the data gets stored as:

�450.00

What do these 3 weird characters mean and how can I make sure the '£' symbol is not replaced by them?

Regards

Gary

[hinch]

answer is simple don't store symbols in a numeric field or if you really insist on doing it insert £450.00 in the db instead then when you response.write it out its the correct html.

at a guess the garbled crap is from a non windows/english browser doing the initial form submit into your db so its coming through on a different charmap and the code transmitted from their browser is different to what yours is interperating it.

rule of thumb never store symbols like that in the db its unnessary.

[Gary Williams]

Hi Hinch,

Nice to hear from you again and thanks for replying. You are quite right, my database design is flawed and displays some poor practice. It was my first decent project and I made some basic errors like mixing symbols with numerics. I'm slowly cleaning out these errors which will solve this particular problem.

I hadn't thought about the possibility of a different charmap and thanks for the 500.100.asp file. It's very useful.

Regards

Gary