Title: TEXT values show as BLOB · Issue #1731 · sqlitebrowser/sqlitebrowser · GitHub
Open Graph Title: TEXT values show as BLOB · Issue #1731 · sqlitebrowser/sqlitebrowser
X Title: TEXT values show as BLOB · Issue #1731 · sqlitebrowser/sqlitebrowser
Description: Details for the issue What did you do? Just had compiled 3.11 from sources, opened my database and execute an query. What did you expect to see? Values in the res_text field actually is text and have a TEXT type accordingly. With previou...
Open Graph Description: Details for the issue What did you do? Just had compiled 3.11 from sources, opened my database and execute an query. What did you expect to see? Values in the res_text field actually is text and ha...
X Description: Details for the issue What did you do? Just had compiled 3.11 from sources, opened my database and execute an query. What did you expect to see? Values in the res_text field actually is text and ha...
Mail addresses
singmin_92@hotmail.com
Opengraph URL: https://github.com/sqlitebrowser/sqlitebrowser/issues/1731
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"TEXT values show as BLOB","articleBody":"\u003c!--\r\nThanks for coming here to report a bug. :)\r\n\r\nPlease describe it in this section, fill out the correct check boxes\r\nbelow with an \"x\", then click the \"Submit new issue\" button at the bottom\r\n-->\r\n\r\nDetails for the issue\r\n--------------------\r\n\r\n#### What did you do?\r\n\r\nJust had compiled 3.11 from sources, opened my database and execute an query.\r\n\r\n#### What did you expect to see?\r\n\r\n\r\n\r\nValues in the `res_text` field actually is text and have a TEXT type accordingly. With previous version 3.10 looks as shown above.\r\n\r\n#### What did you see instead?\r\n\r\nBut with 3.11 I see `BLOB` in the for some values, both in the Browse Data tab and in the Execute SQL tab result pane. SQLite returns `typeof()` as `'text'`. \r\n\r\n\r\n\r\nUseful extra information\r\n-------------------------\r\n\r\nA lot of `res_text` values in my database starts with a newline symbol `\\n`. First screenshot in **What did you expect to see?** section was made in 3.11 too, but after **manually** removing leading newline `\\n` symbol from `res_text` for values with `doc_id` `59867564` and `67412037`. Trim with query `...set res_text=trim(res_text)` has no effect.\r\n\r\nAlso I made a sample of my data as SQL dump, which I upload [to Pastebin](https://pastebin.com/7CyVY338).\r\n\r\n#### What operating system are you using?\r\n\r\n- [ ] Windows: ( _version:_ ___ )\r\n- [x] Linux: ( _distro:_ Arch Linux )\r\n- [ ] Mac OS: ( _version:_ ___ )\r\n- [ ] Other: ___\r\n\r\n#### What is your DB4S version?\r\n\r\n- [X] 3.11.0\r\n- [ ] 3.11.0-alpha1 or 3.11.0-beta*\r\n- [ ] 3.10.1\r\n- [ ] Other: ___\r\n\r\n#### Did you also\r\n\r\n- [ ] Try out the latest nightly version: https://github.com/sqlitebrowser/sqlitebrowser#nightly-builds\r\n- [x] Search for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20\r\n\r\nIt seems looks like #16: Long TEXT values show as (BLOB) since version 3.1.0, \r\nbut `BLOB` mark appears not depends on the length of text. \r\n\r\nRegardless of all above, new version is much faster, thank you :)","author":{"url":"https://github.com/ap-Codkelden","@type":"Person","name":"ap-Codkelden"},"datePublished":"2019-02-07T19:04:18Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/1731"}
| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322 |
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:8de707b5-7ef6-346c-68c0-1c9a7a61150d |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | C106:21B7D6:1638CD:1F23AF:6AFD6E73 |
| html-safe-nonce | 859c38102634250fb827ab101ed0703a7a04407cdc2d2aa634681c4c9b3091fb |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDMTA2OjIxQjdENjoxNjM4Q0Q6MUYyM0FGOjZBRkQ2RTczIiwidmlzaXRvcl9pZCI6IjY5Nzk5ODg1MTgzMjM3MTE2MDMiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | e8fe8c0bf2e0b7ac5b5b8e8f6c98bfbd6b575655261341babec44ae23bb25a9f |
| hovercard-subject-tag | issue:407850401 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlitebrowser/sqlitebrowser/1731/issue_layout |
| twitter:image | https://opengraph.githubassets.com/a57181b9a2e1b0c89c84ee2ba35ad6fe71fd915cf35ae28ebb9438726ff20827/sqlitebrowser/sqlitebrowser/issues/1731 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/a57181b9a2e1b0c89c84ee2ba35ad6fe71fd915cf35ae28ebb9438726ff20827/sqlitebrowser/sqlitebrowser/issues/1731 |
| og:image:alt | Details for the issue What did you do? Just had compiled 3.11 from sources, opened my database and execute an query. What did you expect to see? Values in the res_text field actually is text and ha... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | ap-Codkelden |
| hostname | github.com |
| expected-hostname | github.com |
| None | e54006cf2b96d1ac260960edd10003132911469ccd1ec99c9803119fe2a4e032 |
| turbo-cache-control | no-preview |
| go-import | github.com/sqlitebrowser/sqlitebrowser git https://github.com/sqlitebrowser/sqlitebrowser.git |
| octolytics-dimension-user_id | 7454271 |
| octolytics-dimension-user_login | sqlitebrowser |
| octolytics-dimension-repository_id | 19416551 |
| octolytics-dimension-repository_nwo | sqlitebrowser/sqlitebrowser |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 19416551 |
| octolytics-dimension-repository_network_root_nwo | sqlitebrowser/sqlitebrowser |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 5be0bf2b8cf26f8897d31e6bc3c232d328b12a54 |
| ui-target | canary-2 |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width