Insert / Update Data Display Question

[UndoUndo]

on the insert / update data [right-click feature of a table] is it possible to have the varchar and tinytext fields display their contents like int fields??

thanks

[UndoUndo]

i.e you dont have to click on the field to see the contents

[Ritesh]

I am not sure if I understood the problem. Can you post a screenshot?

[UndoUndo]

the field on the left is INT and the one on the right is varchar. ideally i would like to be able to see the contents of the filed like the int field if possible. This screen is from the “insert/update data” option when right-clicking on a table.

thanks for yr help

[peterlaursen]

You are sure that type is not TEXT ? (not the same as VARCHAR!)

TEXT's are similar to BLOB's except that they have a charset.

What is the SQLyog version you use and the MySQL server version?

How do you conncet?

To me this looks a little strange…

[peterlaursen]

Attached picture shows how a TEXT/BLOB and a CHAR/VARCHAR should display in SLQyog. (this example is 4.2 beta but 4.1 is the same).

the most crazy thing is that it looks as if the button is wider than the column with your system. A little bigger screendump would be usefull!

Addditional questions:

What windows version are you using ?

Ever had other problems with display of GUI elements ?

[Ritesh]

Which version of SQLyog are you using?

[UndoUndo]

Ritesh wrote on Sep 27 2005, 07:23 AM:

Which version of SQLyog are you using?

[post=”7321″]<{POST_SNAPBACK}>[/post]

hi, sorry for the dealy. thanks for yr help on this andthe version is 3.71. The Peter is right the field is a text field!. so i surpose my questions is can the text field be displayed as the varchar or int field?

connection through localhost

I've not had any GUI display problems before.

[UndoUndo]

thanks for the pic Peter, looks like i need to upgrade to 4.1 for the text field to display as per yr pic?

[peterlaursen]

I don't remember if this new display format of TEXTs and BLOBs was introduced with 4.07 or 4.1.

But with a newer SQLyog you will still have to EDIT the text inside the BLOB-viewer. It only DISPLAYS in DATA/RESULT pane.

Varchars are handled more effectively by MySQL than are TEXTs. So if your data don't exceed max. varchar size (256 characters with MySQL 4. and before – more than 60.000 characteres with mySQL 5.0) and if you don't use them with an application that needs TEXT type, I would simply ALTER TABLE to make it VARCHAR.

And yes – I think you should upgrade. Improvements from 3.7 to 4.1/4.2 are too numerous to mention!

[UndoUndo]

thanks, Peter and Ritesh, Really appreciate the help and advice 🙂

[Author]

Posts