René's URL Explorer Experiment


Title: The binary viewer/editor shows the text representation of numeric values instead of their internal representation · Issue #1416 · sqlitebrowser/sqlitebrowser · GitHub

Open Graph Title: The binary viewer/editor shows the text representation of numeric values instead of their internal representation · Issue #1416 · sqlitebrowser/sqlitebrowser

X Title: The binary viewer/editor shows the text representation of numeric values instead of their internal representation · Issue #1416 · sqlitebrowser/sqlitebrowser

Description: I'm looking at a column in a row which is of INTEGER type I am having a hard time understanding the left side marked in red. Isn't this supposed to show the raw binary data? It looks to me that like it's transforming the integer value in...

Open Graph Description: I'm looking at a column in a row which is of INTEGER type I am having a hard time understanding the left side marked in red. Isn't this supposed to show the raw binary data? It looks to me that lik...

X Description: I'm looking at a column in a row which is of INTEGER type I am having a hard time understanding the left side marked in red. Isn't this supposed to show the raw binary data? It looks to me ...

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

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"The binary viewer/editor shows the text representation of numeric values instead of their internal representation","articleBody":"I'm looking at a column in a row which is of INTEGER type\r\n![snip_20180607095319](https://user-images.githubusercontent.com/15019084/41082976-875bfd56-6a1f-11e8-9b26-bc0f2cb4a182.png)\r\n\r\nI am having a hard time understanding the left side marked in red. Isn't this supposed to show the raw binary data?\r\n\r\nIt looks to me that like it's transforming the integer value into a string and then it's showing the hexadecimal representation of the string.\r\n\r\nInstead of \"31\", I was expecting to see \"00 00 00 01\" which is the 4 byte hexa representation of a 32 bits integer. This is how hex viewers would show the value:\r\n\r\n![snip_20180607100049](https://user-images.githubusercontent.com/15019084/41083393-a378ad62-6a20-11e8-9fe5-977fb4590123.png)\r\n\r\nCan someone explain how the viewer\\editor works in SQLiteBrowser?\r\n\r\nIs there a way to see the raw binary data in SQLteBrowser ?\r\n","author":{"url":"https://github.com/opcodewriter","@type":"Person","name":"opcodewriter"},"datePublished":"2018-06-07T07:04:17Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/1416"}

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:eeaf837e-ace5-2781-8172-d3f89bed0ae8
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-id8322:C078E:402F6:5AAB7:6AFDFA3F
html-safe-nonce5748562a2e66481300f2ccc3c72dbdcc1c3f8e5c72b1820ffa4a1ef0a59d6302
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI4MzIyOkMwNzhFOjQwMkY2OjVBQUI3OjZBRkRGQTNGIiwidmlzaXRvcl9pZCI6IjU0NDQ4NTc2MjQ5Mzc3NTcyNDciLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmac06d8b63f42fa7c9febb23741612d0d4ac19ca45854d4ad1b2ae67ec7ce92109b
hovercard-subject-tagissue:330142456
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/1416/issue_layout
twitter:imagehttps://opengraph.githubassets.com/d2700ad1a9628745ecc665eb0e7ff7045f7f6d53869624194dbbbc81a89bfcad/sqlitebrowser/sqlitebrowser/issues/1416
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/d2700ad1a9628745ecc665eb0e7ff7045f7f6d53869624194dbbbc81a89bfcad/sqlitebrowser/sqlitebrowser/issues/1416
og:image:altI'm looking at a column in a row which is of INTEGER type I am having a hard time understanding the left side marked in red. Isn't this supposed to show the raw binary data? It looks to me that lik...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernameopcodewriter
hostnamegithub.com
expected-hostnamegithub.com
Noneee3343385a977757dd145b28fabf4a119780f2615a5a36c5a89f66c9b3b5616d
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
release43ae91995f6e2d5ff7a491f3de438f1f723adeaa
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/sqlitebrowser/sqlitebrowser/issues/1416#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F1416
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%2F1416
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/1416
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1416
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1416
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/1416
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1416
The binary viewer/editor shows the text representation of numeric values instead of their internal representationhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1416#top
enhancementFeature requests.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22enhancement%22
https://github.com/opcodewriter
opcodewriterhttps://github.com/opcodewriter
on Jun 7, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1416#issue-330142456
https://user-images.githubusercontent.com/15019084/41082976-875bfd56-6a1f-11e8-9b26-bc0f2cb4a182.png
https://user-images.githubusercontent.com/15019084/41083393-a378ad62-6a20-11e8-9fe5-977fb4590123.png
https://github.com/chrisjlocke
chrisjlockehttps://github.com/chrisjlocke
on Jun 7, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1416#issuecomment-395322193
https://github.com/opcodewriter
opcodewriterhttps://github.com/opcodewriter
on Jun 7, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1416#issuecomment-395326160
@chrisjlockehttps://github.com/chrisjlocke
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Jun 7, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1416#issuecomment-395478307
justinclifthttps://github.com/justinclift
enhancementFeature requests.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22enhancement%22
on Jun 7, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1416#event-1668989613
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Jun 7, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1416#issuecomment-395544988
mgrojohttps://github.com/mgrojo
on May 5, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1416#event-2319521718
mgrojohttps://github.com/mgrojo
on May 5, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1416#event-2319523923
https://github.com/sky5walk
sky5walkhttps://github.com/sky5walk
on May 5, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1416#issuecomment-489430207
https://github.com/polarbearing
polarbearinghttps://github.com/polarbearing
on Jan 31, 2021https://github.com/sqlitebrowser/sqlitebrowser/issues/1416#issuecomment-770366421
https://user-images.githubusercontent.com/8266355/106382298-e44b2c80-63be-11eb-8bcc-30b47e0b4745.png
https://github.com/chrisjlocke
chrisjlockehttps://github.com/chrisjlocke
on Jan 31, 2021https://github.com/sqlitebrowser/sqlitebrowser/issues/1416#issuecomment-770393881
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Feb 1, 2021https://github.com/sqlitebrowser/sqlitebrowser/issues/1416#issuecomment-771198857
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1416
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1416
enhancementFeature requests.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22enhancement%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.