Database data truncated before second string

Question

Rene 2011-8-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/13439-database-data-truncated-before-second-string

I have a weird problem reading database information. My database contains two columns, a and b. Column a is contains numbers and b contains text. When I use the query

SELECT ALL a FROM etc...

I get all the numbers a intended in a 112x1 cell. The same thing happens when I call only for b, a nice 112x1 cell results.

However using this query

SELECT ALL a,b FROM etc..

the resulting cell look like '1123' 'my text' '423'

stopping before the 2nd text.

Using a query asking for 5 columns containing numbers result in an intended 112x5 cell, including text it puts all the data in a row stopping just before the second text field.

I use matlab 2010a x64. The query work fine on a different computer running 2010b x86.

Thanks for the help!