sql select not returning full string from query
55 次查看(过去 30 天)
显示 更早的评论
My sql select / fetch / sqlread statements are not returning the full string of a field in a table. It also incorrectly identifies the type of the fields. In the first figure below, you can see the data type for the field 'data', and its contents.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/354785/image.png)
in the next figure, you can see the query and the result. It is only giving me the single quote character. Previously, I did not have quotes around this data, and it was giving me the first character (0, -, 1, etc...), so adding the quotes didn't change anything.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/354788/image.png)
When querying with raw sql or python or c# I do not have this issue. Please help! Thanks.
5 个评论
采纳的回答
更多回答(0 个)
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!