mysql problem

admin

Administrator
Staff member
Hello, I have come across something strange in mysql that has never happened to me before.. quick explanation: I am storing phone numbers in the format of XXX-XXXX. My column is defined as varchar(15) (extra in case i need area codes) well, mysql doesn't like to recognize these phone numbers and instead replaces them with two digit numbers.. so all down my phone column it looks like this:
00
08
47
00
23
43

etc.. this is really frustrating.. anyone know what could be causing this and how to fix it?

thanks
blue
 
Back
Top