Integers with symbols in sql tables

Aetheris · 02-19-2012, 11:09 PM

I've created my database table and a php form on my website to upload data to the database. All the fields work fine except for the two "coordinate" fields, which require two sets of numbers separated by a forward slash (ex. 111/222). I've tried using VARCHAR, CHAR and TEXT and INT types, but am getting no results. I've even tried using a comma in place of the slash but with the same negative results. Can someone please help me with this issue?

felgall · 02-20-2012, 01:44 AM

VARCHAR or CHAR should work for a field with content like that if you insist on it being kept in one field. The alternative would be to store the two parts separately in two INT fields.

If it doesn't work when you do that then post the code you are using so we can figure out why.

Aetheris · 02-20-2012, 02:00 AM

Quote:

Originally Posted by felgall

VARCHAR or CHAR should work for a field with content like that if you insist on it being kept in one field. The alternative would be to store the two parts separately in two INT fields.

If it doesn't work when you do that then post the code you are using so we can figure out why.

Thanks, I've gotten no results from VARCHAR or CHAR. The fields just stay blank when I upload a new target info. I'll try the using two fields for the coordinate fields.