Jump to content


This topic is now archived and is closed to further replies.


problems with storing data

Recommended Posts

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.

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.