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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
