Can I insert numbers into varchar data type

Answer 1

Yes you can

Answer 2

thank you to all for help

Answer 3

exe: while($myvar=$myvar1->fetch()){echo (double)$myvar['price'];} where price is à varchar column in you database containing thé pruce

Answer 4

Yes you can, but you will not be able to perform any math towards them because they are considered words. In most cases an address has numbers in a varchar variable.

Answer 5

yes by writing nvarchar

Answer 6

who know char's mean

Answer 7

Yes you can, but it will turn them into strings, so you cannot do math on them without converting them into integers or floats.

Answer 8

yes, you will able to insert any character, number, special character too ..etc

Answer 9

writer characters like Alphabet

Answer 10

yes,you can but if you want to use them as numbers un a program you must do a cast according to à Numerical type of each varchar record from your table with thé correspondant column

Answer 11

thank you to all