Database data truncated before second string
1 回表示 (過去 30 日間)
古いコメントを表示
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!
1 件のコメント
Oleg Komarov
2011 年 8 月 10 日
Usually you cannot connect 64bit MATLAB to 32bit SQL but I guess you managed and this is the result.
採用された回答
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Database Toolbox についてさらに検索
製品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!