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
    Dec 2004
    Location
    Jamaica
    Posts
    592
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Valid characters for access text field????

    what are the valid characters for an MS Access text or memo field?

    and can all this range of characters be represented in the same form that say chr(A) - chr(Z) represents the range for upper case letter A - Z?

  • #2
    New Coder
    Join Date
    Nov 2002
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I think you can put any characters in the text memo field.
    I have run into issues with ODBC getting stuck on ' though.
    For example if you try to send:
    "John's big red bike"
    you might get an odbc error
    but if you escape the '
    "John''s big red bike"
    ODBC is non the wiser.

    I'm not sure if this is just a php+access+odbc issue or not, but that's where it bit me.

  • #3
    raf
    raf is offline
    Master Coder
    Join Date
    Jul 2002
    Posts
    6,589
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Darknight
    I think you can put any characters in the text memo field.
    I have run into issues with ODBC getting stuck on ' though.
    For example if you try to send:
    "John's big red bike"
    you might get an odbc error
    but if you escape the '
    "John''s big red bike"
    ODBC is non the wiser.

    I'm not sure if this is just a php+access+odbc issue or not, but that's where it bit me.
    Not sure what you are asking here.

    if you insert "John''s big red bike" through embedded sql in ASP, then is will sent like that to the db and access will turn it into "John's big red bike"
    but if you insert "John''s big red bike" through embedded sql in PHP, then it will probably automatically addslashes and turn it into "John\'\'s big red bike" and access will choke on it.

    So check with get_magic_quotes_gpc() if the values are automatically escaped by PHP.
    Posting guidelines I use to see if I will spend time to answer your question : http://www.catb.org/~esr/faqs/smart-questions.html


  •  

    Posting Permissions

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