René's URL Explorer Experiment


Title: Cell edit window considers binary data to be text/numeric if first byte is in ascii range · Issue #1772 · sqlitebrowser/sqlitebrowser · GitHub

Open Graph Title: Cell edit window considers binary data to be text/numeric if first byte is in ascii range · Issue #1772 · sqlitebrowser/sqlitebrowser

X Title: Cell edit window considers binary data to be text/numeric if first byte is in ascii range · Issue #1772 · sqlitebrowser/sqlitebrowser

Description: Details for the issue What did you do? Select a blob column while browsing a table. What did you expect to see? I expected to see the data represented as binary since the column affinity for the column is BLOB What did you see instead? O...

Open Graph Description: Details for the issue What did you do? Select a blob column while browsing a table. What did you expect to see? I expected to see the data represented as binary since the column affinity for the co...

X Description: Details for the issue What did you do? Select a blob column while browsing a table. What did you expect to see? I expected to see the data represented as binary since the column affinity for the co...

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

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Cell edit window considers binary data to be text/numeric if first byte is in ascii range","articleBody":"Details for the issue\r\n--------------------\r\n\r\n#### What did you do?\r\nSelect a blob column while browsing a table.\r\n\r\n#### What did you expect to see?\r\nI expected to see the data represented as binary since the column affinity for the column is BLOB\r\n\r\n#### What did you see instead?\r\nOn columns where the first byte of the binary header is outside of ASCII printable range, it shows the data as binary with the correct count of bytes.\r\n\r\nThe columns where the first byte of the binary header is within ASCII printable range, it shows the data as text/numeric with 1 char(s), instead of 32 bytes. \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- [x] Windows: ( _version:7 Pro version 6.1 Build 7601 SP1)\r\n\r\n\r\n#### What is your DB4S version?\r\n\r\n- [x] 3.11.1\r\n\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","author":{"url":"https://github.com/mbenningfield1","@type":"Person","name":"mbenningfield1"},"datePublished":"2019-02-28T22:21:23Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/1772"}

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:050e6000-7b37-ce20-4744-4eeb642c3a19
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idCC60:4253C:1D0C4:27DD5:6AFD6620
html-safe-nonce4997e3ee470fb7d3cdcbecba54645df79c64db0b2b69e31b38105b71fb60a9b5
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDQzYwOjQyNTNDOjFEMEM0OjI3REQ1OjZBRkQ2NjIwIiwidmlzaXRvcl9pZCI6IjU3MDA0OTM4NzY1MzIxNzY0MTYiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmac79c26379c4165db85d16738248fe8280a4064cd0113249210b5e20e65cb0f7d4
hovercard-subject-tagissue:415850592
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/1772/issue_layout
twitter:imagehttps://opengraph.githubassets.com/ce4d21a0692f44ad2bfa674234173e2855736986a56fbb903075c3cba4e12402/sqlitebrowser/sqlitebrowser/issues/1772
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/ce4d21a0692f44ad2bfa674234173e2855736986a56fbb903075c3cba4e12402/sqlitebrowser/sqlitebrowser/issues/1772
og:image:altDetails for the issue What did you do? Select a blob column while browsing a table. What did you expect to see? I expected to see the data represented as binary since the column affinity for the co...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernamembenningfield1
hostnamegithub.com
expected-hostnamegithub.com
None42a67d7c7488271ca8d7e6dc3942424e6de3bff43b1ed4a9c6f0e1a69b73b389
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
release5c3779ac05f3590d8d7ea0c02b14e678ae8179ae
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/sqlitebrowser/sqlitebrowser/issues/1772#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F1772
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%2F1772
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/1772
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1772
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1772
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/1772
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1772
Cell edit window considers binary data to be text/numeric if first byte is in ascii rangehttps://github.com/sqlitebrowser/sqlitebrowser/issues/1772#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.2https://github.com/sqlitebrowser/sqlitebrowser/milestone/17
https://github.com/mbenningfield1
mbenningfield1https://github.com/mbenningfield1
on Feb 28, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#issue-415850592
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
Nexthttps://github.com/sqlitebrowser/sqlitebrowser/issues/1772?timeline_page=1
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 Mar 1, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#event-2172700502
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Mar 1, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#issuecomment-468493032
https://github.com/mbenningfield1
mbenningfield1https://github.com/mbenningfield1
on Mar 1, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#issuecomment-468514548
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Mar 1, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#issuecomment-468804434
https://github.com/sky5walk
sky5walkhttps://github.com/sky5walk
on Mar 1, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#issuecomment-468808223
https://github.com/mbenningfield1
mbenningfield1https://github.com/mbenningfield1
on Mar 1, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#issuecomment-468819106
https://user-images.githubusercontent.com/22527582/53667608-1c77ec80-3c37-11e9-9530-c4c3381a6681.png
https://user-images.githubusercontent.com/22527582/53667612-1f72dd00-3c37-11e9-8ef6-19df23d45c90.png
mbenningfield1https://github.com/mbenningfield1
completedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on Mar 1, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#event-2175177858
mbenningfield1https://github.com/mbenningfield1
on Mar 1, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#event-2175180742
https://github.com/mbenningfield1
mbenningfield1https://github.com/mbenningfield1
on Mar 1, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#issuecomment-468819636
https://github.com/sky5walk
sky5walkhttps://github.com/sky5walk
on Mar 1, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#issuecomment-468820472
https://github.com/mbenningfield1
mbenningfield1https://github.com/mbenningfield1
on Mar 1, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#issuecomment-468821834
@sky5walkhttps://github.com/sky5walk
mgrojohttps://github.com/mgrojo
on Mar 1, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#event-2175299097
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Mar 1, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#issuecomment-468836640
#1731https://github.com/sqlitebrowser/sqlitebrowser/issues/1731
justinclifthttps://github.com/justinclift
3.11.2https://github.com/sqlitebrowser/sqlitebrowser/milestone/17
on Mar 2, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#event-2175455077
mgrojohttps://github.com/mgrojo
on Mar 2, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#event-2175752050
Fix text detection for blobs containing bytes in ASCII range up to a …https://github.com/sqlitebrowser/sqlitebrowser/commit/0adb0af13342f5a12cbfae43ae2b5a176b6a21ea
0adb0afhttps://github.com/sqlitebrowser/sqlitebrowser/commit/0adb0af13342f5a12cbfae43ae2b5a176b6a21ea
https://github.com/mbenningfield1
mbenningfield1https://github.com/mbenningfield1
on Mar 6, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#issuecomment-469964074
LoremIpsum.txthttps://github.com/sqlitebrowser/sqlitebrowser/files/2934293/LoremIpsum.txt
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Mar 6, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#issuecomment-469972156
@mbenningfield1https://github.com/mbenningfield1
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Mar 7, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#issuecomment-470671049
https://forum.qt.io/topic/42464/qplaintextedit-eats-line-endings/5https://forum.qt.io/topic/42464/qplaintextedit-eats-line-endings/5
https://github.com/sky5walk
sky5walkhttps://github.com/sky5walk
on Mar 7, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#issuecomment-470699209
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Mar 7, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#issuecomment-470721001
mgrojohttps://github.com/mgrojo
on Mar 7, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#event-2188736208
Make clear we are counting characters and not bytes or C char(s)https://github.com/sqlitebrowser/sqlitebrowser/commit/fc73ff4e5caf92164389b738b7acc4d2d72c1de8
fc73ff4https://github.com/sqlitebrowser/sqlitebrowser/commit/fc73ff4e5caf92164389b738b7acc4d2d72c1de8
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Mar 7, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#issuecomment-470737918
https://github.com/mbenningfield1
mbenningfield1https://github.com/mbenningfield1
on Mar 7, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#issuecomment-470738952
@mgrojohttps://github.com/mgrojo
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Mar 7, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#issuecomment-470739966
@mbenningfield1https://github.com/mbenningfield1
mgrojohttps://github.com/mgrojo
completedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on Mar 7, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#event-2188759063
https://github.com/sky5walk
sky5walkhttps://github.com/sky5walk
on Mar 7, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#issuecomment-470746205
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Mar 8, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#issuecomment-470774521
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Mar 8, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#issuecomment-470774944
mgrojohttps://github.com/mgrojo
on Mar 12, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1772#event-2198682402
Fix text detection for blobs containing bytes in ASCII range up to a …https://github.com/sqlitebrowser/sqlitebrowser/commit/b412f9d2b6782735bf291ccb88a7f083464a9f2b
b412f9dhttps://github.com/sqlitebrowser/sqlitebrowser/commit/b412f9d2b6782735bf291ccb88a7f083464a9f2b
Detect data with embedded zeros as binary also for ISO-8859https://github.com/sqlitebrowser/sqlitebrowser/commit/d0fef81d9e1648cde6b32623a69e84878ad98087
d0fef81https://github.com/sqlitebrowser/sqlitebrowser/commit/d0fef81d9e1648cde6b32623a69e84878ad98087
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1772
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1772
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.2https://github.com/sqlitebrowser/sqlitebrowser/milestone/17
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.