René's URL Explorer Experiment


Title: Long TEXT values show as (BLOB) since version 3.1.0 · Issue #16 · sqlitebrowser/sqlitebrowser · GitHub

Open Graph Title: Long TEXT values show as (BLOB) since version 3.1.0 · Issue #16 · sqlitebrowser/sqlitebrowser

X Title: Long TEXT values show as (BLOB) since version 3.1.0 · Issue #16 · sqlitebrowser/sqlitebrowser

Description: Just started using the much-improved v3.1.0 via PortableApps - Thanks! However, I now find that columns with a declared type of TEXT with values which are UTF-8 strings longer than 1024 bytes now appear as (BLOB), both in the Browse Data...

Open Graph Description: Just started using the much-improved v3.1.0 via PortableApps - Thanks! However, I now find that columns with a declared type of TEXT with values which are UTF-8 strings longer than 1024 bytes now a...

X Description: Just started using the much-improved v3.1.0 via PortableApps - Thanks! However, I now find that columns with a declared type of TEXT with values which are UTF-8 strings longer than 1024 bytes now a...

Mail addresses
peinthor@gmail.com

Opengraph URL: https://github.com/sqlitebrowser/sqlitebrowser/issues/16

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Long TEXT values show as (BLOB) since version 3.1.0","articleBody":"Just started using the much-improved v3.1.0 via PortableApps - Thanks!\nHowever, I now find that columns with a declared type of TEXT with values which are UTF-8 strings longer than 1024 bytes now appear as (BLOB), both in the Browse Data tab and in the Execute SQL tab result pane. SQLite returns typeof() as 'text'.\nNot sure what the previous PortableApps version was, but it displayed text values as text all the way up to my longest string of about 13K.\nIs this a limit that you could consider raising/removing? (browsing/editing BLOB data is a tad less friendly than TEXT data!)\n","author":{"url":"https://github.com/stevehodgett","@type":"Person","name":"stevehodgett"},"datePublished":"2014-05-24T15:17:27Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/16"}

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:3cc45d3e-6907-b7b9-8d7b-106c603de2b1
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-id8AA6:2723BB:95E47A:CE3A92:6AFD33FC
html-safe-nonce963721bfc3e001e720f64f9274f52bb2b8345d09c527a006822410d9b23b51ea
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI4QUE2OjI3MjNCQjo5NUU0N0E6Q0UzQTkyOjZBRkQzM0ZDIiwidmlzaXRvcl9pZCI6IjU0MzE4Mjc2MjE4NzQ1Nzg0MjgiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmaca388ce5b2895079fd9c13b8394664d7ef9edf93d9fb8ed8d28ef9a4e6584ef27
hovercard-subject-tagissue:34235958
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/16/issue_layout
twitter:imagehttps://opengraph.githubassets.com/d80286a96511272e0322531dc17105772eb8f017421c495b8969408193815322/sqlitebrowser/sqlitebrowser/issues/16
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/d80286a96511272e0322531dc17105772eb8f017421c495b8969408193815322/sqlitebrowser/sqlitebrowser/issues/16
og:image:altJust started using the much-improved v3.1.0 via PortableApps - Thanks! However, I now find that columns with a declared type of TEXT with values which are UTF-8 strings longer than 1024 bytes now a...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernamestevehodgett
hostnamegithub.com
expected-hostnamegithub.com
None065128366c233a9d57ff68ab6c96e25b99dd1b0ab70d23b70873d3dd6b5e4f19
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
release941021edf0c2ec58298f4a2c8f27ae507d129c92
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/sqlitebrowser/sqlitebrowser/issues/16#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F16
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%2F16
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/16
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/16
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/16
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/16
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/16
Long TEXT values show as (BLOB) since version 3.1.0https://github.com/sqlitebrowser/sqlitebrowser/issues/16#top
https://github.com/MKleusberg
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.2 - Codename Radianthttps://github.com/sqlitebrowser/sqlitebrowser/milestone/2
https://github.com/stevehodgett
stevehodgetthttps://github.com/stevehodgett
on May 24, 2014https://github.com/sqlitebrowser/sqlitebrowser/issues/16#issue-34235958
https://github.com/rp-
rp-https://github.com/rp-
on May 24, 2014https://github.com/sqlitebrowser/sqlitebrowser/issues/16#issuecomment-44091079
https://github.com/rp-
rp-https://github.com/rp-
on May 24, 2014https://github.com/sqlitebrowser/sqlitebrowser/issues/16#issuecomment-44091174
rp-https://github.com/rp-
rp-https://github.com/rp-
MKleusberghttps://github.com/MKleusberg
rp-https://github.com/rp-
on May 24, 2014https://github.com/sqlitebrowser/sqlitebrowser/issues/16#event-124514911
https://github.com/rp-
rp-https://github.com/rp-
on May 24, 2014https://github.com/sqlitebrowser/sqlitebrowser/issues/16#issuecomment-44091457
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on May 24, 2014https://github.com/sqlitebrowser/sqlitebrowser/issues/16#issuecomment-44093732
rp-https://github.com/rp-
on May 24, 2014https://github.com/sqlitebrowser/sqlitebrowser/issues/16#event-124526317
Don't show cells with long text values as BLOBhttps://github.com/sqlitebrowser/sqlitebrowser/commit/516d71f1467b6907da76d8766f489c59edcd12c5
516d71fhttps://github.com/sqlitebrowser/sqlitebrowser/commit/516d71f1467b6907da76d8766f489c59edcd12c5
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on May 24, 2014https://github.com/sqlitebrowser/sqlitebrowser/issues/16#issuecomment-44095875
MKleusberghttps://github.com/MKleusberg
completedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on May 24, 2014https://github.com/sqlitebrowser/sqlitebrowser/issues/16#event-124526516
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on May 24, 2014https://github.com/sqlitebrowser/sqlitebrowser/issues/16#issuecomment-44097168
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on May 24, 2014https://github.com/sqlitebrowser/sqlitebrowser/issues/16#issuecomment-44098012
@rp-https://github.com/rp-
@stevehodgetthttps://github.com/stevehodgett
http://rp.oldsch00l.com/sqlitebrowser/sqlitebrowser.exe.xzhttp://rp.oldsch00l.com/sqlitebrowser/sqlitebrowser.exe.xz
https://github.com/stevehodgett
stevehodgetthttps://github.com/stevehodgett
on May 24, 2014https://github.com/sqlitebrowser/sqlitebrowser/issues/16#issuecomment-44099561
https://github.com/rp-
rp-https://github.com/rp-
on May 24, 2014https://github.com/sqlitebrowser/sqlitebrowser/issues/16#issuecomment-44102410
http://rp.oldsch00l.com/sqlitebrowser/http://rp.oldsch00l.com/sqlitebrowser/
@MKleusberghttps://github.com/MKleusberg
https://github.com/stevehodgett
stevehodgetthttps://github.com/stevehodgett
on May 25, 2014https://github.com/sqlitebrowser/sqlitebrowser/issues/16#issuecomment-44125717
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on May 25, 2014https://github.com/sqlitebrowser/sqlitebrowser/issues/16#issuecomment-44127355
@rp-https://github.com/rp-
https://github.com/rp-
rp-https://github.com/rp-
on May 25, 2014https://github.com/sqlitebrowser/sqlitebrowser/issues/16#issuecomment-44127445
justinclifthttps://github.com/justinclift
bughttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22bug%22
on May 28, 2014https://github.com/sqlitebrowser/sqlitebrowser/issues/16#event-125361453
justinclifthttps://github.com/justinclift
3.2 - Codename Radianthttps://github.com/sqlitebrowser/sqlitebrowser/milestone/2
on May 28, 2014https://github.com/sqlitebrowser/sqlitebrowser/issues/16#event-125361466
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/16
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/16
MKleusberghttps://github.com/MKleusberg
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.2 - Codename Radianthttps://github.com/sqlitebrowser/sqlitebrowser/milestone/2
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.