Azzera filtri
Azzera filtri

Info

Questa domanda è chiusa. Riaprila per modificarla o per rispondere.

Unable to retrieve string from MySQL

1 visualizzazione (ultimi 30 giorni)
Amir Abedin
Amir Abedin il 9 Lug 2020
Chiuso: MATLAB Answer Bot il 20 Ago 2021
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
  1 Commento
Amir Abedin
Amir Abedin il 9 Lug 2020
I figured out the problem. Mysql field character set must be utf8 for string type.

Risposte (0)

Questa domanda è chiusa.

Community Treasure Hunt

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

Start Hunting!

Translated by