Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    Regular Coder
    Join Date
    Sep 2002
    Location
    South East UK. 35 miles east of London, in sight of the River Thames.
    Posts
    297
    Thanks
    10
    Thanked 0 Times in 0 Posts

    I'm Storing Weird (�) Characters

    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

  • #2
    Regular Coder hinch's Avatar
    Join Date
    Sep 2005
    Location
    UK
    Posts
    923
    Thanks
    25
    Thanked 80 Times in 80 Posts
    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.
    A programmer is just a tool which converts caffeine into code

    My work: http://www.fcsoftware.co.uk && http://www.firstcontactcrm.com
    My hobby: http://www.angel-computers.co.uk
    My life: http://www.furious-angels.com

  • #3
    Regular Coder
    Join Date
    Sep 2002
    Location
    South East UK. 35 miles east of London, in sight of the River Thames.
    Posts
    297
    Thanks
    10
    Thanked 0 Times in 0 Posts
    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


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •