Title: Import Table from CSV is Not Preserving Quoted Values as Text · Issue #1382 · sqlitebrowser/sqlitebrowser · GitHub
Open Graph Title: Import Table from CSV is Not Preserving Quoted Values as Text · Issue #1382 · sqlitebrowser/sqlitebrowser
X Title: Import Table from CSV is Not Preserving Quoted Values as Text · Issue #1382 · sqlitebrowser/sqlitebrowser
Description: Details for the issue Problem: Import Table from CSV is not preserving quoted values as text. Using Import - Table from CSV File, I am trying to import this csv file into an empty database. Values are double quoted to indicate that they ...
Open Graph Description: Details for the issue Problem: Import Table from CSV is not preserving quoted values as text. Using Import - Table from CSV File, I am trying to import this csv file into an empty database. Values ...
X Description: Details for the issue Problem: Import Table from CSV is not preserving quoted values as text. Using Import - Table from CSV File, I am trying to import this csv file into an empty database. Values ...
Opengraph URL: https://github.com/sqlitebrowser/sqlitebrowser/issues/1382
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Import Table from CSV is Not Preserving Quoted Values as Text","articleBody":"### Details for the issue\r\n\r\nProblem: Import Table from CSV is not preserving quoted values as text.\r\n\r\nUsing Import - Table from CSV File, I am trying to import [this csv file](https://github.com/frankpd/storage/blob/master/ruralurbancodes2013.csv) into an empty database. Values are double quoted to indicate that they should be preserved as text - for example, the FIPS column contains values that are five digit numbers with leading zeros, and these values are all double quoted.\r\n\r\nWhen I import CSV, I leave the default quote character choice as double quotes, and the FIPS values I see in the preview look fine. But when I hit OK, it does the import and saves this column as an Integer, ignoring the double quotes. As a result the leading zeros from the values are dropped and the codes are no longer correct.\r\n\r\nI tried all of the following, with no effect: leaving the trim option off, going under View - Preferences - Database and changing the default field type from Integer to Text, adding an integer id column in the CSV before the FIPS column (in case the first column is reserved as an integer key column), using single instead of double quotes to preserve text.\r\n\r\nI'm using Version 3.10.99 SQLite Version 3.11.0. I'm running 64-bit Linux Mint 18.2 and am using the linuxgndu sqlitebrowser for ubuntu xenial.\r\n\r\n\r\n\r\n\r\n\r\n### Useful extra information\r\n\r\n\u003c!-- The info below often helps, please fill it out if you're able to. :) -->\r\n\r\n#### I'm opening this issue because:\r\n\r\n- [ ] DB4S is crashing\r\n- [ x] DB4S has a bug\r\n- [ ] DB4S needs a feature\r\n- [ ] DB4S has another problem\r\n\r\n#### I'm using DB4S on:\r\n\r\n- [ ] Windows: ( _version:_ ___ )\r\n- [x ] Linux: ( _distro:_ ubuntu xenial___ )\r\n- [ ] Mac OS: ( _version:_ ___ )\r\n- [ ] Other: ___\r\n\r\n#### I'm using 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__\r\n\r\n#### I have also:\r\n\r\n- [ ] Tried out the latest nightly version: https://github.com/sqlitebrowser/sqlitebrowser#nightly-builds\r\n- [x ] Searched 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/frankpd","@type":"Person","name":"frankpd"},"datePublished":"2018-05-09T16:06:48Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/1382"}
| 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:53fb97c9-d571-ca84-0f02-22baffb5ed4d |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | B2DC:13288B:18A291:20AB02:6AFD1103 |
| html-safe-nonce | e49fc437ac3f50fddb3f7102111265b30ed79e4187fb5841bae18779529dfde3 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCMkRDOjEzMjg4QjoxOEEyOTE6MjBBQjAyOjZBRkQxMTAzIiwidmlzaXRvcl9pZCI6IjMyOTY1NjQ5NzY4OTc4MjI5NzkiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | e8bbd824f078dca4beb4f10a074f3a247cab776fe184a8a54e5def52428aa1e6 |
| hovercard-subject-tag | issue:321632687 |
| 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/1382/issue_layout |
| twitter:image | https://opengraph.githubassets.com/25b2f6b654094665a1484e01ae6330c474fcc83d3fa8e160d24de31a89cf8744/sqlitebrowser/sqlitebrowser/issues/1382 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/25b2f6b654094665a1484e01ae6330c474fcc83d3fa8e160d24de31a89cf8744/sqlitebrowser/sqlitebrowser/issues/1382 |
| og:image:alt | Details for the issue Problem: Import Table from CSV is not preserving quoted values as text. Using Import - Table from CSV File, I am trying to import this csv file into an empty database. Values ... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | frankpd |
| hostname | github.com |
| expected-hostname | github.com |
| None | 7c34e25df4e46e972c8f0225e63410231bdeb9ea5634597c712796bbcdb2e627 |
| 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 | 8fa571ebaa95e4e6bf872197c0e84b7dc48e6785 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width