telephone number problem

[ceanth]

hi all i have the following table:

Create Table student
(student_no varchar(5),
student_name varchar (30),
student_address varchar (30),
student_tel number (11),
Primary Key (student_no));

The problem i am having is that student tel does not allow a '0' to be inserted as the first number, so if i insert a number say "0123" when i search or display all info in the table i get "123"

[darkfunkel]

you could do e.g.

$telephone1 = $telephone{1};
$telephone2 = $telephone;
if ($telephone1 != 0) {

Run an array here to substitute e.g. 1 to 01 2 to 02 etc

}
print $resultfromarray;
$rest1 = substr($telephone2, 1);    

print $rest1;

[superwormy]

Change the telephone number to VARCHAR instead of INT

[ceanth]

i dont have access to my sql database at the moment (will try tomorrow) but would it therefore be:

Create Table student
(student_no varchar(5),
student_name varchar (30),
student_address varchar (30),
student_tel int (11),
Primary Key (student_no));

[darkfunkel]

I always use text and substr to limit as I find it most adaptable