René's URL Explorer Experiment


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

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@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![image](https://user-images.githubusercontent.com/1292133/52432623-9115aa80-2b13-11e9-97fa-4e7b6dc448d3.png)\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![image](https://user-images.githubusercontent.com/1292133/52432060-2f087580-2b12-11e9-8ce1-5c64dabf3cc3.png)\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-profiling0
react-import-mapreact,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-controllervoltron_issues_fragments
route-actionissue_layout
fetch-noncev2:8de707b5-7ef6-346c-68c0-1c9a7a61150d
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idC106:21B7D6:1638CD:1F23AF:6AFD6E73
html-safe-nonce859c38102634250fb827ab101ed0703a7a04407cdc2d2aa634681c4c9b3091fb
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDMTA2OjIxQjdENjoxNjM4Q0Q6MUYyM0FGOjZBRkQ2RTczIiwidmlzaXRvcl9pZCI6IjY5Nzk5ODg1MTgzMjM3MTE2MDMiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmace8fe8c0bf2e0b7ac5b5b8e8f6c98bfbd6b575655261341babec44ae23bb25a9f
hovercard-subject-tagissue:407850401
github-keyboard-shortcutsrepository,issues,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/issues_fragments/issue_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlitebrowser/sqlitebrowser/1731/issue_layout
twitter:imagehttps://opengraph.githubassets.com/a57181b9a2e1b0c89c84ee2ba35ad6fe71fd915cf35ae28ebb9438726ff20827/sqlitebrowser/sqlitebrowser/issues/1731
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/a57181b9a2e1b0c89c84ee2ba35ad6fe71fd915cf35ae28ebb9438726ff20827/sqlitebrowser/sqlitebrowser/issues/1731
og:image:altDetails 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:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernameap-Codkelden
hostnamegithub.com
expected-hostnamegithub.com
Nonee54006cf2b96d1ac260960edd10003132911469ccd1ec99c9803119fe2a4e032
turbo-cache-controlno-preview
go-importgithub.com/sqlitebrowser/sqlitebrowser git https://github.com/sqlitebrowser/sqlitebrowser.git
octolytics-dimension-user_id7454271
octolytics-dimension-user_loginsqlitebrowser
octolytics-dimension-repository_id19416551
octolytics-dimension-repository_nwosqlitebrowser/sqlitebrowser
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id19416551
octolytics-dimension-repository_network_root_nwosqlitebrowser/sqlitebrowser
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release5be0bf2b8cf26f8897d31e6bc3c232d328b12a54
ui-targetcanary-2
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/sqlitebrowser/sqlitebrowser/issues/1731#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F1731
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F1731
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=sqlitebrowser%2Fsqlitebrowser
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1731
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1731
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1731
sqlitebrowserhttps://github.com/sqlitebrowser
sqlitebrowserhttps://github.com/sqlitebrowser/sqlitebrowser
Codehttps://github.com/sqlitebrowser/sqlitebrowser
Issues786 (786)https://github.com/sqlitebrowser/sqlitebrowser/issues
Pull requests30 (30)https://github.com/sqlitebrowser/sqlitebrowser/pulls
Discussionshttps://github.com/sqlitebrowser/sqlitebrowser/discussions
Actionshttps://github.com/sqlitebrowser/sqlitebrowser/actions
Projectshttps://github.com/sqlitebrowser/sqlitebrowser/projects
Wikihttps://github.com/sqlitebrowser/sqlitebrowser/wiki
Security and qualityhttps://github.com/sqlitebrowser/sqlitebrowser/security
Insightshttps://github.com/sqlitebrowser/sqlitebrowser/insights
https://github.com/sqlitebrowser/sqlitebrowser
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1731
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1731
TEXT values show as BLOBhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1731#top
https://github.com/mgrojo
bugConfirmed bugs or reports that are very likely to be bugs.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22bug%22
3.11.1https://github.com/sqlitebrowser/sqlitebrowser/milestone/16
https://github.com/ap-Codkelden
ap-Codkeldenhttps://github.com/ap-Codkelden
on Feb 7, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#issue-407850401
https://user-images.githubusercontent.com/1292133/52432623-9115aa80-2b13-11e9-97fa-4e7b6dc448d3.png
https://user-images.githubusercontent.com/1292133/52432060-2f087580-2b12-11e9-8ce1-5c64dabf3cc3.png
to Pastebinhttps://pastebin.com/7CyVY338
https://github.com/sqlitebrowser/sqlitebrowser#nightly-buildshttps://github.com/sqlitebrowser/sqlitebrowser#nightly-builds
https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20
#16https://github.com/sqlitebrowser/sqlitebrowser/issues/16
Nexthttps://github.com/sqlitebrowser/sqlitebrowser/issues/1731?timeline_page=1
https://github.com/chrisjlocke
chrisjlockehttps://github.com/chrisjlocke
on Feb 7, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#issuecomment-461558523
https://github.com/ap-Codkelden
ap-Codkeldenhttps://github.com/ap-Codkelden
on Feb 7, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#issuecomment-461566451
@chrisjlockehttps://github.com/chrisjlocke
https://user-images.githubusercontent.com/1292133/52437179-ec00cf00-2b1e-11e9-9a6f-127b6d422c9e.png
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Feb 7, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#issuecomment-461640325
sqlitebrowser/src/Data.cpphttps://github.com/sqlitebrowser/sqlitebrowser/blob/0ad00afcbea78c2996f5fecba00618dde41c40d3/src/Data.cpp#L13
0ad00afhttps://github.com/sqlitebrowser/sqlitebrowser/commit/0ad00afcbea78c2996f5fecba00618dde41c40d3
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Feb 8, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#issuecomment-461642034
justinclifthttps://github.com/justinclift
bugConfirmed bugs or reports that are very likely to be bugs.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22bug%22
on Feb 8, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#event-2126046534
mgrojohttps://github.com/mgrojo
on Feb 9, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#event-2128714466
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Feb 9, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#issuecomment-462041327
@ap-Codkeldenhttps://github.com/ap-Codkelden
issue_1731.patch.txthttps://github.com/sqlitebrowser/sqlitebrowser/files/2847800/issue_1731.patch.txt
#1658https://github.com/sqlitebrowser/sqlitebrowser/issues/1658
mgrojohttps://github.com/mgrojo
on Feb 9, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#event-2128845872
Fix text detection checkhttps://github.com/sqlitebrowser/sqlitebrowser/commit/e2443d685fae620f6e5ce21eb25c3356006f8527
e2443d6https://github.com/sqlitebrowser/sqlitebrowser/commit/e2443d685fae620f6e5ce21eb25c3356006f8527
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Feb 9, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#issuecomment-462066126
@ap-Codkeldenhttps://github.com/ap-Codkelden
mgrojohttps://github.com/mgrojo
response requestedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22response%20requested%22
on Feb 9, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#event-2128846797
mgrojohttps://github.com/mgrojo
3.11.1https://github.com/sqlitebrowser/sqlitebrowser/milestone/16
on Feb 9, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#event-2128846939
https://github.com/ap-Codkelden
ap-Codkeldenhttps://github.com/ap-Codkelden
on Feb 9, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#issuecomment-462067216
@mgrojohttps://github.com/mgrojo
#1658https://github.com/sqlitebrowser/sqlitebrowser/issues/1658
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Feb 9, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#issuecomment-462070983
#1658https://github.com/sqlitebrowser/sqlitebrowser/issues/1658
this problemhttps://bugreports.qt.io/browse/QTBUG-73721
mgrojohttps://github.com/mgrojo
completedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on Feb 9, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#event-2128873681
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Feb 9, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#issuecomment-462088711
@mgrojohttps://github.com/mgrojo
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Feb 28, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#issuecomment-468431084
@ap-Codkeldenhttps://github.com/ap-Codkelden
#1461 (comment)https://github.com/sqlitebrowser/sqlitebrowser/issues/1461#issuecomment-403320868
@chrisjlockehttps://github.com/chrisjlocke
@mgrojohttps://github.com/mgrojo
@justinclifthttps://github.com/justinclift
@Shouqunhttps://github.com/Shouqun
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Feb 28, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#issuecomment-468483735
https://github.com/singminhong
singminhonghttps://github.com/singminhong
on Mar 1, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#issuecomment-468559840
@mgrojohttps://github.com/mgrojo
https://user-images.githubusercontent.com/15607744/53620430-e5e9a400-3c2d-11e9-9c7b-3b8de08c6b89.jpg
@chrisjlockehttps://github.com/chrisjlocke
@mgrojohttps://github.com/mgrojo
@justinclifthttps://github.com/justinclift
@Shouqunhttps://github.com/Shouqun
@justinclifthttps://github.com/justinclift
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Mar 1, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#issuecomment-468571217
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-usershttp://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Mar 1, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#issuecomment-468572085
https://github.com/skerit
skerithttps://github.com/skerit
on Jul 2, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#issuecomment-507831264
https://user-images.githubusercontent.com/755212/60544063-3aa24600-9d18-11e9-9584-ac22df292b32.png
https://github.com/chrisjlocke
chrisjlockehttps://github.com/chrisjlocke
on Jul 2, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#issuecomment-507836843
https://github.com/skerit
skerithttps://github.com/skerit
on Jul 2, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#issuecomment-507845825
Ultrastar.ziphttps://github.com/sqlitebrowser/sqlitebrowser/files/3352341/Ultrastar.zip
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Jul 2, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#issuecomment-507856705
https://github.com/skerit
skerithttps://github.com/skerit
on Jul 2, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#issuecomment-507860921
https://github.com/paul1149
paul1149https://github.com/paul1149
on Jan 13, 2022https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#issuecomment-1011695761
https://github.com/chrisjlocke
chrisjlockehttps://github.com/chrisjlocke
on Jan 13, 2022https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#issuecomment-1011879291
https://github.com/paul1149
paul1149https://github.com/paul1149
on Jan 18, 2022https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#issuecomment-1015004843
https://github.com/chrisjlocke
chrisjlockehttps://github.com/chrisjlocke
on Jan 18, 2022https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#issuecomment-1015148652
https://user-images.githubusercontent.com/7872218/149892438-aeb7e7ca-9549-4cbf-9259-1e6af6d92c3e.png
https://github.com/paul1149
paul1149https://github.com/paul1149
on Jan 20, 2022https://github.com/sqlitebrowser/sqlitebrowser/issues/1731#issuecomment-1016989801
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1731
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1731
mgrojohttps://github.com/mgrojo
bugConfirmed bugs or reports that are very likely to be bugs.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22bug%22
3.11.1https://github.com/sqlitebrowser/sqlitebrowser/milestone/16
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.