Hello,
Quoting from MySQL docs for CONCAT() :
CONCAT(str1, str2, …)
Returns the string that results from concatenating the arguments. May have one or more arguments. If all arguments are nonbinary strings, the result is a nonbinary string. If the arguments include any binary strings, the result is a binary string. A numeric argument is converted to its equivalent string form. This is a nonbinary string as of MySQL 5.5.3. Before 5.5.3, it is a binary string; to avoid that and produce a nonbinary string, you can use an explicit type cast, as in this example:
SELECT CONCAT(CAST(int_col AS CHAR), char_col);
SQLyog grid view only displays the first 64 characters in the grid view of result/table data tab if the TEXT datatype is of ‘binary’ character-set.
Hence I would suggest you to cast the ‘testid’ field as CHAR in your queries, since the version of MySQL server you are connecting to appears to be pre 5.5.3.
You will then be able to see the result of the column in the grid view without truncation at 64th character.
Regards,
Sudhindra Bhat
