List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:June 27 2006 10:37am
Subject:Re: TINYTEXT != VARCHAR(255) ? (Advanced Data Generator related)
View as plain text  
Hello Denis,

>
> I have a question related to the two MySQL data types mentioned in the
> subject. Are they totally identical or not?
>
>
> I am asking this question due to the problem I am facing right now. The
> thing is that yesterday I downloaded a tool named Advanced Data Generator
> for MySQL (by Upscene Productions) and tried to fill my database with some
> test data. However I was not able to set the option named "Fill with" to
> "Preset" for TINYTEXT fields while it is allowed for VARCHAR fields. This
> means that that tool makes some difference between these two types, but
why?

TinyText is recognized as "(text) blob". Good call though, it should
probably
be recognized as a varying length character type instead.

However -- did you download the MySQL Edition or the Pro Edition which
uses ADO or ODBC connectivity? I can imagine that if you're using ODBC,
the driver would return it as text-blob, in which there's no way to
recognize
the special tinytext type.

> AFAIK some of the developers of this tool are here on the list so any
advice
> from them will be highly appreciated!

You can continue writing me personally instead :-)

Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Thread
TINYTEXT != VARCHAR(255) ? (Advanced Data Generator related)Denis Gerasimov27 Jun
  • Re: TINYTEXT != VARCHAR(255) ? (Advanced Data Generator related)Martijn Tonies27 Jun