"(MEMO)" in mySQL ?

[Anon]

Hello!

In mySQL-Front i got "MEMO" in some of the cells(moste when they are texttype), when I changed the datatype to "text"....why...? I would like to see what it contain instead ...?

Even when I set a new columnname, as texttype it gives me "memo"

🙁(((

Klas

[bretticus]

Sounds like mySQL-Front mimics MS Access terminology ;-)

TEXT or BLOB fields in database applications will commonly show as (TEXT) or even (MEMO) in the cells that have so much content.

There are plenty of GUIs for MySQL out there. Use another if you need to see what's there. MySQL is mostly used for Web development and therefore, no one cares too much about seeing the data with a GUI as long as they can throw the content on a Web page ;-)

Have fun!

[Anon]

Yes. I understand it as text is used for huge textamonts, that's why they put "memo", i found out i could see the content on another place later. I now use varchar instead, and it works fine.

Thanks.

Klas