Text, Long Text, BLOB ?

[Anon]

While trying to import a table from MS Access to MySql, I lost some data going from a text field (255 chars max) to an MsSql text field. I searched in vain thru the online doc to find info on data types for MySql.

Can anyone tell me the char limits for MySql text, medium text, long text, BLOB, etc. ? And why all these different data types when MS Access needs only two: text and Memo?

Thanks.

[[deleted]]

methinks you read the online docs with your eyes closed.

http://www.mysql.com/doc/C/o/Column_types.html

[Anon]

Sorry, I only did a search on terms like "BLOB" and "Long Text" which produced no results. Perhaps their indexing needs to be improved :-)

Thanks, and I'll check this out.

[Anon]

The do cover this subject fully. Not sure why my search on "blob" resulted in no results, could have been some Internet goblin at the time.

So I see that a MySql varchar field == text field in MS Access (255 chars max).

And a MySql BLOB (or text) field == MS Access Memo * 2 for storage space.

Good stuff to know when porting between tables.

[[deleted]]

"Perhaps their indexing needs to be improved"

No sh*t? :-) if you put "datatypes" it returns zero results. very usefull 🙂

[Anon]

No matter how good we get technologicaly, we haven't gone anywhere, if we don't somehow improve our written & spoken language.