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
Domain: github.com
{"@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\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-profiling | 0 |
| react-import-map | react,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-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:6f9aff13-212f-c786-9b79-f3740bc911a6 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | A5F4:4FEF:2C7F1A:3E58C2:6AFD7567 |
| html-safe-nonce | 29bdfd79cd80341fa7c43fb759ca623ad4f5ed1cea407880b41caed6e3deccca |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBNUY0OjRGRUY6MkM3RjFBOjNFNThDMjo2QUZENzU2NyIsInZpc2l0b3JfaWQiOiI0NTM5MjYwODAxNzI4ODEyNTUiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | 77b7c214a0e626999c2c296dfcf5161e159b06dc9cbd55ac55bf4677d65e6d14 |
| hovercard-subject-tag | issue:338660896 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlitebrowser/sqlitebrowser/1461/issue_layout |
| twitter:image | https://opengraph.githubassets.com/4cfcb81ce6ad2edd9a2479ae83cafdb17cc5b3490f00bd252117975658036609/sqlitebrowser/sqlitebrowser/issues/1461 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/4cfcb81ce6ad2edd9a2479ae83cafdb17cc5b3490f00bd252117975658036609/sqlitebrowser/sqlitebrowser/issues/1461 |
| og:image:alt | 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... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | tlhackque |
| hostname | github.com |
| expected-hostname | github.com |
| None | e54006cf2b96d1ac260960edd10003132911469ccd1ec99c9803119fe2a4e032 |
| turbo-cache-control | no-preview |
| go-import | github.com/sqlitebrowser/sqlitebrowser git https://github.com/sqlitebrowser/sqlitebrowser.git |
| octolytics-dimension-user_id | 7454271 |
| octolytics-dimension-user_login | sqlitebrowser |
| octolytics-dimension-repository_id | 19416551 |
| octolytics-dimension-repository_nwo | sqlitebrowser/sqlitebrowser |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 19416551 |
| octolytics-dimension-repository_network_root_nwo | sqlitebrowser/sqlitebrowser |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 5be0bf2b8cf26f8897d31e6bc3c232d328b12a54 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width