From: Martijn Tonies
Date: March 1 2005 2:49pm
Subject: Re: field varchar and char truncate the ended blank characters
List-Archive: http://lists.mysql.com/mysql/180723
Message-Id: <023901c51e6d$ed073bf0$3802a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hello,


> Using TEXT or BLOB prevent me to display the string in a dbgrid, the real
> data is replaced by a text like "(MEMO)".
> I can use somethinh like "select substring( msg, 1,100 ) from mytable " to
> bypass the problem but is no the clean solution I looking for.
> I thank for your hints but I'm looking, if possible, for a different
> solution.
> Other ideas ?

Is this using Delphi? If so - you might want to create an OnGetText
event for the field and pass (part of the) TEXT as a simple string.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com