What are the Field Types Available, and record character limitations in PHP and MY SQL any typical Formats that are standard would be helpful

RUA Volunteer2?
RUA Volunteer2? used Ask the Experts™
I need to know where to find limitations on size of record in characters say for a string field and or a memo field, (is it limited to 254) how dates are formatted. Anything related to the fields records character limits formatting etc for a database like php /my admin

If you were to know offhand what the limits of a memo fields are in character length that would be helpful. Thank you.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Fixer of Problems
Most Valuable Expert 2014
Here's a link to the MySQL data types: http://dev.mysql.com/doc/refman/5.1/en/data-types.html  . I don't see a 'memo' type listed.
"memo" data type does not exist in mysql, but it is equivalentz to TEXT data type in mysql. There is no such thing as php/myadmn.
PHP usually is coupled with MySQL database,and there are following datatypes in MySQL:

  • CHAR( ) String with fixed length0 to 255 characters long.
  • VARCHAR( ) String with variable length,maximum from 0 to 255 characters
  • TINYTEXT String,maximum length of 255 characters.
  • TEXTA String,maximum length of 65535 characters (equivalent to MEMO)
  • BLOB Binary string,maximum length of 65535 characters.
  • LONGTEXT A string with a maximum length of 4294967295 characters.
  • LONGBLOB A string with a maximum length of 4294967295 characters.
  • INT Integer represented with four bytes, values  -2147483648  to 2147483647
  • BIGINT A large integer values –9223372036854775808 to 9223372036854775807
  • FLOAT  Small (single-precision) floating-point number
  • DATE Stores date
  • TIME Stores  time
..and many more datatypes,just to name few.
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.


Thank you gentlemen. So if I wanted to somehow (and I don't know how ) embed a "Blob" or "LongBlob" field into custom html code say in a Joomla website custom html module (if you are firmilar) Thus having web pages that change with the records in the database dynamically...?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial