sql select not returning full string from query
50 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Tim Darrah
el 1 de Sept. de 2020
Respondida: Tim Darrah
el 18 de Sept. de 2020
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 comentarios
Respuesta aceptada
Más respuestas (0)
Ver también
Categorías
Más información sobre Application Deployment en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!