Unable to retrieve string from MySQL

1 次查看（过去 30 天）

Amir Abedin 2020-7-9

关闭： MATLAB Answer Bot 2021-8-20

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 2020-7-9

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

此问题已关闭。

此问题已关闭。

Find the treasures in MATLAB Central and discover how the community can help you!

Translated by