René's URL Explorer Experiment


Title: [Bug]: Database cell type not updated properly when copy/pasting blob data · Issue #3307 · sqlitebrowser/sqlitebrowser · GitHub

Open Graph Title: [Bug]: Database cell type not updated properly when copy/pasting blob data · Issue #3307 · sqlitebrowser/sqlitebrowser

X Title: [Bug]: Database cell type not updated properly when copy/pasting blob data · Issue #3307 · sqlitebrowser/sqlitebrowser

Description: What did you do? When copying BLOB data into cells in the database which contain TEXT data, the BLOB will be copied into the cell and DB4S will display the type as BLOB, but when the database is read through the sqlite3 command line or p...

Open Graph Description: What did you do? When copying BLOB data into cells in the database which contain TEXT data, the BLOB will be copied into the cell and DB4S will display the type as BLOB, but when the database is re...

X Description: What did you do? When copying BLOB data into cells in the database which contain TEXT data, the BLOB will be copied into the cell and DB4S will display the type as BLOB, but when the database is re...

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

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[Bug]: Database cell type not updated properly when copy/pasting blob data","articleBody":"### What did you do?\n\nWhen copying `BLOB` data into cells in the database which contain `TEXT` data, the `BLOB` will be copied into the cell and DB4S will display the type as `BLOB`, but when the database is read through the `sqlite3` command line or python library it will be read as an empty `TEXT` field.\r\n\r\n### Steps to Reproduce:\r\n1. Create a new database and initialize as follows\r\n```sql\r\nCREATE TABLE \"test_table\" ( \"field\" BLOB );\r\nINSERT INTO \"test_table\" (\"field\") VALUES (X'DEADBEEF');\r\nINSERT INTO \"test_table\" (\"field\") VALUES (\"String\");\r\n```\r\n2. Open the database in DB4S and go to the \"Browse Data\" tab\r\n3. Use `ctrl`+`c` and `ctrl`+`v` to copy the `BLOB` value over the `TEXT` value\r\n4. Write the changes to the database\r\n\r\n### Verifying through `sqlite3` cli\r\n1. Open the database `sqlite3 /path/to/database.db`\r\n2. Dump raw data with `.dump`\r\n```sql\r\n-- Output abridged \r\nINSERT INTO test_table VALUES(X'deadbeef');\r\nINSERT INTO test_table VALUES('ޭ��');  -- BLOB field is output as corrupt TEXT\r\n```\r\n\r\n### Verifying through python's `sqlite3` module\r\nUsing the following script\r\n```py\r\nimport sqlite3\r\n\r\nconn = sqlite3.connect('/path/to/database.db')\r\ncursor = sqlite3.Cursor(conn)\r\ncursor.execute(\"SELECT field FROM test_table\")\r\nfor row in cursor.fetchall():\r\n    print(type(row[0]), row[0])\r\n```\r\nDepending on the exact binary data in the `BLOB` field the script will either crash with `sqlite3.OperationalError: Could not decode to UTF-8 column 'field' with text'����'` or will output the bytes field directly interpreted as UTF-8.\r\n\n\n### What did you expect to see?\n\nI expected the `BLOB` value to be exactly copied over the text cell so that the two output lines of the `.dump` command would be identical.\n\n### What did you see instead?\n\nThe `BLOB` data was saved as corrupt text. Depending on how this data is retrieved, it either comes out as garbled text or crashes the program due to invalid UTF-8 encoding.\n\n### DB4S Version\n\n3.12.2\n\n### What OS are you seeing the problem on?\n\nLinux\n\n### OS version\n\nArch Linux\n\n### Relevant log output\n\n_No response_\n\n### Prevention against duplicate issues\n\n- [X] I have searched for similar issues","author":{"url":"https://github.com/nhhollander","@type":"Person","name":"nhhollander"},"datePublished":"2023-03-28T00:48:18Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/3307"}

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:4fe5a248-cb64-beae-1078-21362a5e207b
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idCE8A:1F037:19BF77:223C6D:6AFD1185
html-safe-noncec4e98b57771db73b3b69b6a2f23d7e55e2421d587558c64c0696623e6d9f7c04
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDRThBOjFGMDM3OjE5QkY3NzoyMjNDNkQ6NkFGRDExODUiLCJ2aXNpdG9yX2lkIjoiODUyNTM4MDQxMDcwMjM2OTE1NyIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac60d76e8eef6cf6db62e7791f8c3f693f080ea9675c751e8c0ed134f8f7bea678
hovercard-subject-tagissue:1643028219
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/3307/issue_layout
twitter:imagehttps://opengraph.githubassets.com/b6ee99bf8b614d62036cbc8a76dabaf93633abc8e2e503a973b9bfe163373de7/sqlitebrowser/sqlitebrowser/issues/3307
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/b6ee99bf8b614d62036cbc8a76dabaf93633abc8e2e503a973b9bfe163373de7/sqlitebrowser/sqlitebrowser/issues/3307
og:image:altWhat did you do? When copying BLOB data into cells in the database which contain TEXT data, the BLOB will be copied into the cell and DB4S will display the type as BLOB, but when the database is re...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernamenhhollander
hostnamegithub.com
expected-hostnamegithub.com
None7c34e25df4e46e972c8f0225e63410231bdeb9ea5634597c712796bbcdb2e627
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
release8fa571ebaa95e4e6bf872197c0e84b7dc48e6785
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/sqlitebrowser/sqlitebrowser/issues/3307#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F3307
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%2F3307
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/3307
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/3307
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/3307
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/3307
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/3307
[Bug]: Database cell type not updated properly when copy/pasting blob datahttps://github.com/sqlitebrowser/sqlitebrowser/issues/3307#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/nhhollander
nhhollanderhttps://github.com/nhhollander
on Mar 28, 2023https://github.com/sqlitebrowser/sqlitebrowser/issues/3307#issue-1643028219
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Mar 28, 2023https://github.com/sqlitebrowser/sqlitebrowser/issues/3307#issuecomment-1486056856
https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/continuoushttps://github.com/sqlitebrowser/sqlitebrowser/releases/tag/continuous
https://github.com/nhhollander
nhhollanderhttps://github.com/nhhollander
on Mar 28, 2023https://github.com/sqlitebrowser/sqlitebrowser/issues/3307#issuecomment-1486059930
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Mar 28, 2023https://github.com/sqlitebrowser/sqlitebrowser/issues/3307#issuecomment-1486067889
@nhhollanderhttps://github.com/nhhollander
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
release blockerBugs that are serious enough to block our next releasehttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22release%20blocker%22
on Mar 28, 2023https://github.com/sqlitebrowser/sqlitebrowser/issues/3307#event-8859773068
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Mar 28, 2023https://github.com/sqlitebrowser/sqlitebrowser/issues/3307#issuecomment-1486072651
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Mar 28, 2023https://github.com/sqlitebrowser/sqlitebrowser/issues/3307#issuecomment-1486073088
@MKleusberghttps://github.com/MKleusberg
@mgrojohttps://github.com/mgrojo
@scottfurryhttps://github.com/scottfurry
@lucydodohttps://github.com/lucydodo
https://github.com/i-s-o
i-s-ohttps://github.com/i-s-o
on Mar 28, 2023https://github.com/sqlitebrowser/sqlitebrowser/issues/3307#issuecomment-1486863930
data typehttps://www.sqlite.org/datatype3.html
https://user-images.githubusercontent.com/1661549/228246404-940bb4c1-9b57-41fb-bdbc-e84c984306bf.gif
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Mar 28, 2023https://github.com/sqlitebrowser/sqlitebrowser/issues/3307#issuecomment-1486973991
data typehttps://www.sqlite.org/datatype3.html
https://github.com/chrisjlocke
chrisjlockehttps://github.com/chrisjlocke
on Mar 28, 2023https://github.com/sqlitebrowser/sqlitebrowser/issues/3307#issuecomment-1486997685
https://user-images.githubusercontent.com/7872218/228270232-a2988d7f-663c-4c85-ba66-8b71d929c291.png
https://github.com/chrisjlocke
chrisjlockehttps://github.com/chrisjlocke
on Mar 28, 2023https://github.com/sqlitebrowser/sqlitebrowser/issues/3307#issuecomment-1487017129
https://user-images.githubusercontent.com/7872218/228273714-1d09f779-d220-49f8-babc-db19e91c8f55.png
@i-s-ohttps://github.com/i-s-o
https://github.com/nhhollander
nhhollanderhttps://github.com/nhhollander
on Mar 28, 2023https://github.com/sqlitebrowser/sqlitebrowser/issues/3307#issuecomment-1487290781
mgrojohttps://github.com/mgrojo
on Aug 4, 2023https://github.com/sqlitebrowser/sqlitebrowser/issues/3307#event-10012048540
Paste non-text data as BLOBhttps://github.com/sqlitebrowser/sqlitebrowser/commit/9475f31d6db3063629f1d582defa942a8c72f52c
9475f31https://github.com/sqlitebrowser/sqlitebrowser/commit/9475f31d6db3063629f1d582defa942a8c72f52c
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Aug 4, 2023https://github.com/sqlitebrowser/sqlitebrowser/issues/3307#issuecomment-1666030915
SQLite type affinityhttps://www.sqlite.org/datatype3.html#type_affinity
mgrojohttps://github.com/mgrojo
on Aug 4, 2023https://github.com/sqlitebrowser/sqlitebrowser/issues/3307#event-10012145290
mgrojohttps://github.com/mgrojo
release blockerBugs that are serious enough to block our next releasehttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22release%20blocker%22
on Aug 4, 2023https://github.com/sqlitebrowser/sqlitebrowser/issues/3307#event-10012145679
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Aug 4, 2023https://github.com/sqlitebrowser/sqlitebrowser/issues/3307#issuecomment-1666036479
@nhhollanderhttps://github.com/nhhollander
nightly buildhttps://github.com/sqlitebrowser/sqlitebrowser/wiki/Nightly-Builds
mgrojohttps://github.com/mgrojo
on Oct 14, 2023https://github.com/sqlitebrowser/sqlitebrowser/issues/3307#event-10655923087
Paste non-text data as BLOBhttps://github.com/sqlitebrowser/sqlitebrowser/commit/44e9f9aab7fd5845df020fb48d52758f9abfde44
44e9f9ahttps://github.com/sqlitebrowser/sqlitebrowser/commit/44e9f9aab7fd5845df020fb48d52758f9abfde44
https://github.com/sky5walk
sky5walkhttps://github.com/sky5walk
on Apr 16, 2024https://github.com/sqlitebrowser/sqlitebrowser/issues/3307#issuecomment-2059440615
https://github.com/chrisjlocke
chrisjlockehttps://github.com/chrisjlocke
on Apr 16, 2024https://github.com/sqlitebrowser/sqlitebrowser/issues/3307#issuecomment-2059920959
https://github.com/sky5walk
sky5walkhttps://github.com/sky5walk
on Apr 16, 2024https://github.com/sqlitebrowser/sqlitebrowser/issues/3307#issuecomment-2059927623
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/3307
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/3307
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.