i have a tsble field which is defined as varchar(11) for storing mobile phone number.
the values should be in this format: 999-999999.
when i run an UPDATE query, it stores it with different value and without the "-".
but when i write it directly to the database with mysql-front there is no problem.
so, what should i do?
let me just say that i know about the option of seperating the two values into two different fields, but i would prefer it to be done as explained.
problems with storing data
1 reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users