René's URL Explorer Experiment


Title: Binary cell dump not visible - with no scrollbars (and it's not even a real blob) · Issue #1461 · sqlitebrowser/sqlitebrowser · GitHub

Open Graph Title: Binary cell dump not visible - with no scrollbars (and it's not even a real blob) · Issue #1461 · sqlitebrowser/sqlitebrowser

X Title: Binary cell dump not visible - with no scrollbars (and it's not even a real blob) · Issue #1461 · sqlitebrowser/sqlitebrowser

Description: Details for the issue What did you do? Selected a database cell classified as a "blob" What did you expect to see? binary and ascii dump Everything is grayed-out, perhaps because the DB is open Read-Only. What did you see instead? only l...

Open Graph Description: Details for the issue What did you do? Selected a database cell classified as a "blob" What did you expect to see? binary and ascii dump Everything is grayed-out, perhaps because the DB is open Rea...

X Description: Details for the issue What did you do? Selected a database cell classified as a "blob" What did you expect to see? binary and ascii dump Everything is grayed-out, perhaps because the DB i...

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

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Binary cell dump not visible - with no scrollbars (and it's not even a real blob)","articleBody":"Details for the issue\r\n--------------------\r\n\r\n#### What did you do?\r\nSelected a database cell classified as a \"blob\"\r\n\r\n#### What did you expect to see?\r\nbinary and ascii dump  Everything is grayed-out, perhaps because the DB is open Read-Only.\r\n\r\n#### What did you see instead?\r\nonly leftmost 2 chars of ascii dump\r\nNo horizontal scrollbars.\r\n\r\n![image](https://user-images.githubusercontent.com/332018/42336894-152bc5b4-8053-11e8-96cb-968c647014c4.png)\r\n\r\nIt is also mildly annoy that the single G1 character ('E4'), which is a valid Latin-1 graphic character suffices to make this text look like a blob.\r\n\r\nE4 is \"small a dieresis or umlaut\"\r\n\r\nThe binary test should require C0 or C1 control characters; G1 graphics are not an indication of binary data.\r\n\r\nFor ISO standard (non-MS) text:\r\n\r\nThe C0 range is 0x00 - 0x1F (Text can be expected to have some of these:\r\n09 - ht, 0a - lf, 0b - vt, 0c - ff, 0d - cr, and in some cases, 1b -esc and 1a (^z)\r\n\r\nThe C1 range is 0x80 - 0x9F none of which are common in ANSI text.  (Windows, however does many of these for graphics.)\r\n\r\nThe G0 range is 0x20 - 0x7e (7f is DEL).\r\nThe G1 range is 0xA0 - 0xFF.\r\n\r\nI would say that a field is \"binary\" if it has any bytes in the C0 set (except as noted) or any of the C1 set.\r\n\r\nSome might disagree because of the Microsoft usage.  \r\n\r\nA very common (and simple) test for \"binary\" is the presence of a 0 (NUL) byte.    It's not foolproof - a slightly enhanced version is if 0 bytes constitute more than a small (say, 10) percentage of the data - in text structures, 0 tends to be a terminator....\r\n\r\nThe latter test is probably the best choice here... it's simple, effective, and avoids the Microsoft issue.\r\n\r\n(I might mention byte order marks and other Unicode indicators, but this note is already too long.)\r\n\r\nUseful extra information\r\n-------------------------\r\n\r\nThe info below often helps, please fill it out if you're able to. :)\r\n\r\n#### What operating system are you using?\r\n\r\n- [xc ] Windows: ( _version:_10 pro ___ )\r\n- [ ] Linux: ( _distro:_ ___ )\r\n- [ ] Mac OS: ( _version:_ ___ )\r\n- [ ] Other: ___\r\n\r\n#### What is your DB4S version?\r\n\r\n- [ ] 3.10.1\r\n- [ ] 3.10.0\r\n- [ ] 3.9.1\r\n- [x ] Other: _3.10.99 5-Jul\r\n\r\n#### Did you also\r\n\r\n- [x ] Try out the latest nightly version: https://github.com/sqlitebrowser/sqlitebrowser#nightly-builds\r\n- [ ] Search for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20\r\n","author":{"url":"https://github.com/tlhackque","@type":"Person","name":"tlhackque"},"datePublished":"2018-07-05T17:21:51Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/1461"}

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:6f9aff13-212f-c786-9b79-f3740bc911a6
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idA5F4:4FEF:2C7F1A:3E58C2:6AFD7567
html-safe-nonce29bdfd79cd80341fa7c43fb759ca623ad4f5ed1cea407880b41caed6e3deccca
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBNUY0OjRGRUY6MkM3RjFBOjNFNThDMjo2QUZENzU2NyIsInZpc2l0b3JfaWQiOiI0NTM5MjYwODAxNzI4ODEyNTUiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmac77b7c214a0e626999c2c296dfcf5161e159b06dc9cbd55ac55bf4677d65e6d14
hovercard-subject-tagissue:338660896
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/1461/issue_layout
twitter:imagehttps://opengraph.githubassets.com/4cfcb81ce6ad2edd9a2479ae83cafdb17cc5b3490f00bd252117975658036609/sqlitebrowser/sqlitebrowser/issues/1461
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/4cfcb81ce6ad2edd9a2479ae83cafdb17cc5b3490f00bd252117975658036609/sqlitebrowser/sqlitebrowser/issues/1461
og:image:altDetails for the issue What did you do? Selected a database cell classified as a "blob" What did you expect to see? binary and ascii dump Everything is grayed-out, perhaps because the DB is open Rea...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernametlhackque
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-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/sqlitebrowser/sqlitebrowser/issues/1461#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F1461
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%2F1461
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/1461
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1461
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1461
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/1461
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1461
Binary cell dump not visible - with no scrollbars (and it's not even a real blob)https://github.com/sqlitebrowser/sqlitebrowser/issues/1461#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
https://github.com/tlhackque
tlhackquehttps://github.com/tlhackque
on Jul 5, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1461#issue-338660896
https://user-images.githubusercontent.com/332018/42336894-152bc5b4-8053-11e8-96cb-968c647014c4.png
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
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Jul 5, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1461#issuecomment-402800840
sqlitebrowser/src/EditDialog.cpphttps://github.com/sqlitebrowser/sqlitebrowser/blob/9174abea4dc95b27da93ef7adbad7e7b54c683ac/src/EditDialog.cpp#L705-L734
9174abehttps://github.com/sqlitebrowser/sqlitebrowser/commit/9174abea4dc95b27da93ef7adbad7e7b54c683ac
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Jul 5, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1461#issuecomment-402801582
sqlitebrowser/src/Data.cpphttps://github.com/sqlitebrowser/sqlitebrowser/blob/9174abea4dc95b27da93ef7adbad7e7b54c683ac/src/Data.cpp#L13-L29
9174abehttps://github.com/sqlitebrowser/sqlitebrowser/commit/9174abea4dc95b27da93ef7adbad7e7b54c683ac
https://github.com/tlhackque
tlhackquehttps://github.com/tlhackque
on Jul 5, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1461#issuecomment-402807994
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Jul 5, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1461#issuecomment-402808402
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 Jul 5, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1461#event-1718706062
https://github.com/tlhackque
tlhackquehttps://github.com/tlhackque
on Jul 5, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1461#issuecomment-402810005
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Jul 5, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1461#issuecomment-402812359
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Jul 5, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1461#issuecomment-402813049
https://github.com/tlhackque
tlhackquehttps://github.com/tlhackque
on Jul 5, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1461#issuecomment-402816040
https://github.com/tlhackque
tlhackquehttps://github.com/tlhackque
on Jul 5, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1461#issuecomment-402816850
mgrojohttps://github.com/mgrojo
on Jul 7, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1461#event-1721653059
mgrojohttps://github.com/mgrojo
on Jul 8, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1461#event-1721820081
Issue #1461: Binary cell dump not visible - with no scrollbarshttps://github.com/sqlitebrowser/sqlitebrowser/commit/8f1f55bf3d5231214e477f43be4b6dbecdb45968
#1461https://github.com/sqlitebrowser/sqlitebrowser/issues/1461
8f1f55bhttps://github.com/sqlitebrowser/sqlitebrowser/commit/8f1f55bf3d5231214e477f43be4b6dbecdb45968
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Jul 8, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1461#issuecomment-403320868
@tlhackquehttps://github.com/tlhackque
https://github.com/tlhackque
tlhackquehttps://github.com/tlhackque
on Jul 8, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1461#issuecomment-403324865
unicode.orghttps://www.unicode.org/versions/Unicode6.2.0/ch02.pdf
unicode.orghttps://www.unicode.org/versions/Unicode6.2.0/ch16.pdf
unicode.orghttps://www.unicode.org/versions/Unicode6.2.0/ch03.pdf
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Jul 9, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1461#issuecomment-403363791
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Jul 9, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1461#issuecomment-403613888
https://github.com/tlhackque
tlhackquehttps://github.com/tlhackque
on Aug 23, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1461#issuecomment-415412094
https://user-images.githubusercontent.com/332018/44527282-64302100-a6b4-11e8-8ba7-8cea6007bca3.png
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1461
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1461
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
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.