sql select not returning full string from query
50 views (last 30 days)
Show older comments
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 Comments
Accepted Answer
More Answers (0)
See Also
Categories
Find more on Application Deployment in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!