Jump to content

I am in phpmyadmin, making a table, what type should I use for 25,50,160 string?


physaux

Recommended Posts

VarChar would be correct type. If the string can go past 255, then text would probably be the preferred method.

 

VARCHAR length limit is 65,535 since MySQL 5.0.3

 

If your strings are ALWAYS of same length (like MD5 hashes) then use CHAR().

VarChar would be correct type. If the string can go past 255, then text would probably be the preferred method.

 

VARCHAR length limit is 65,535 since MySQL 5.0.3

 

Wow, I am way behind the times...lol on my dev box I still run mysql 3.x :X granted I havnt really coded any projects for a while, I guess having the subquery feature in MySQL will be nice, time for  an upgrade I guess and to read up on MySQL 5.x

am way behind the times...lol on my dev box I still run mysql 3.x :X granted I havnt really coded any projects for a while, I guess having the subquery feature in MySQL will be nice

 

Yeah... and triggers, views, scheduler, table partitioning, TIMESTAMP that has some sense, pluggable storage engines... :D

Archived

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

×
×
  • Create New...

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.