#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2000
    Posts
    44
    Rep Power
    15
    Just wondering what character limitations exist in reference to storing text into a table.

    For example, if I wish to store some sort of a description within a database, am I allowed ( ) - _ + = ' " ; : / ? . < > , http:// etc. ?

    If not, what is a good way to get around this?

    Decius.
  2. #2
  3. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Location
    Perth West Australia
    Posts
    757
    Rep Power
    15
    MySQL will let you store anything - but a lot of people avoid allowing '<' & '>' to stop from having to check user input for malicious code, the only other problem I have found is that you have to decide on a character to set aside as a field delimiter , often commas in text input can appear to a database to be the end of a field, which can be really annoying when exporting/importing data etc.

    Simon

    ------------------
    Simon Wheeler
    FirePages -DHTML/PHP/MySQL

Similar Threads

  1. Invalid characters with PHP and MySQL
    By gio50000 in forum MySQL Help
    Replies: 2
    Last Post: November 18th, 2004, 09:59 AM
  2. Replies: 3
    Last Post: July 10th, 2003, 08:47 PM
  3. Error 1045 & MySQL Configuration
    By ksp in forum MySQL Help
    Replies: 10
    Last Post: June 30th, 2003, 08:16 PM
  4. mysql at the command prompt
    By Smo in forum MySQL Help
    Replies: 6
    Last Post: April 9th, 2003, 09:07 AM
  5. MySQL Load Limitations
    By jbuckle24 in forum PHP Development
    Replies: 2
    Last Post: August 29th, 2001, 02:52 PM

IMN logo majestic logo threadwatch logo seochat tools logo