フィルターのクリア

sql select not returning full string from query

55 ビュー (過去 30 日間)
Tim Darrah
Tim Darrah 2020 年 9 月 1 日
回答済み: Tim Darrah 2020 年 9 月 18 日
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.
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.
When querying with raw sql or python or c# I do not have this issue. Please help! Thanks.
  5 件のコメント
Tim Darrah
Tim Darrah 2020 年 9 月 17 日
編集済み: Tim Darrah 2020 年 9 月 17 日
Thank you for your advice, I will look into these suggestions. Yeah, I get the entire data sample with other languages.
Tim Darrah
Tim Darrah 2020 年 9 月 17 日
Changed the datatype to text, works. Thanks for pointing me in the right direction!

サインインしてコメントする。

採用された回答

Tim Darrah
Tim Darrah 2020 年 9 月 18 日
Changed the datatype to text, works. Thanks for pointing me in the right direction!

その他の回答 (0 件)

カテゴリ

Help Center および File ExchangeApplication Deployment についてさらに検索

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by