Fastest Web Hosting

which data type should i use to store alphanumeric content in mysql

0 votes
asked Nov 11, 2016 in Mysql by rajatinsa (3,350 points)

User have filed to store his address , which datatype i should use to store it in mysql. I Used TEXT but as i searched TEXT takes too much space so please suggest me

1 Answer

0 votes
answered Nov 11, 2016 by Manoj Insan (1,600 points)

Try with VARCHAR

it can save maximum 255 digit of alphanumeric ...so i think address can be long 255 digit...

so you can use it

Job Board

TechnicalSharp is a technical community of developers where they are sharing their knowledge and solutions and against it they are getting the score point which help them to make profile strong which is under eyes on MNC's
...