Unable to retrieve string from MySQL

I am connecting to mysql database and retrieveing a row. The returned data only contains database fields that cointain integer but not strings.

cmd = 'SELECT * FROM table.stim WHERE sid =%d';

A1=3;

cmd = sprintf(cmd,A1);

query = sprintf(cmd);

conn = database('','admin','');

data = select(conn, cmd);

close(conn)

clear conn query

The returned data:

120 10 ''

actual database row:

120 10 s6-2-red-mr-xs.png

so I can retrieve the fieds with integer values, but the mysql field with "s6-2-red-mr-xs.png" is retutned as ''

Any help appreciated. Thank you

[Amir Abedin]

I figured out the problem. Mysql field character set must be utf8 for string type.