{"action":"created","issue":{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/731","repository_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser","labels_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/731/labels{/name}","comments_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/731/comments","events_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/731/events","html_url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/731","id":171188715,"number":731,"title":"CR's being stripped from multi-line fields?","user":{"login":"chrisjlocke","id":7872218,"avatar_url":"https://avatars.githubusercontent.com/u/7872218?v=3","gravatar_id":"","url":"https://api.github.com/users/chrisjlocke","html_url":"https://github.com/chrisjlocke","followers_url":"https://api.github.com/users/chrisjlocke/followers","following_url":"https://api.github.com/users/chrisjlocke/following{/other_user}","gists_url":"https://api.github.com/users/chrisjlocke/gists{/gist_id}","starred_url":"https://api.github.com/users/chrisjlocke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chrisjlocke/subscriptions","organizations_url":"https://api.github.com/users/chrisjlocke/orgs","repos_url":"https://api.github.com/users/chrisjlocke/repos","events_url":"https://api.github.com/users/chrisjlocke/events{/privacy}","received_events_url":"https://api.github.com/users/chrisjlocke/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-08-15T15:03:07Z","updated_at":"2016-08-16T10:03:12Z","closed_at":null,"body":"### Details for the issue\r\n\r\n<!--\r\n\r\nThanks for coming here to report an issue. :)\r\n\r\nPlease describe it in this section, fill out the correct check boxes\r\nbelow with an \"x\", then click the \"Submit new issue\" button at the bottom\r\n\r\n-->\r\n\r\nWhen entering multi-line data in DB4S, the data is changed so that CRLF is changed to LF.\r\nPossibly.\r\n\r\nPlease see this screencast.\r\nhttp://screencast-o-matic.com/watch/cDjo29iM8o\r\n\r\nI enter 123 456 789 (split on 3 lines) from my Windows program.  This loads and saves fine.  DB4S shows this as 3  lines.  If I add a further line, 000, my program now sees it as one string.  HOWEVER, if I press the right arrow at a set interval (not easy to pick up as there is no audio!) you can see the cursor 'stick' where the new lines should be - the textbox is seeing a LF but being Windows, doesn't know what to do with it.\r\n\r\nExporting the field to a text file and viewing that in Notepad++, shows LFs, not CRLFs.\r\nExporting the field the first time, showed CRLFs.\r\nNotepad++ sees it as a 'Unix' file.\r\nViewing the field in DB4S correctly shows the 4 lines.  Copying that to the clipboard correctly shows CRLFs.  Its as if the data is wrong, but DB4S 'corrects' it.\r\n\r\n![image](https://cloud.githubusercontent.com/assets/7872218/17668556/bf4aa1c6-6301-11e6-8da4-ab13dfd5f79f.png)\r\n\r\n\r\nAdditional testing.  Correcting the text in DB4S mangles it further.  A mix of CRLF and LF.  However, additional saving DOES NOT mangle it further (ie, editing does not compound the issue)  \r\n![image](https://cloud.githubusercontent.com/assets/7872218/17668600/061560aa-6302-11e6-8d0c-877e59f5768b.png)\r\n\r\n\r\n\r\n\r\n### Useful extra information\r\n\r\n<!-- 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- [x] Windows\r\n- [ ] Linux: ( _distro:_ ___ )\r\n- [ ] Mac OS\r\n- [ ] Other: ___\r\n\r\n#### I'm using DB4S version:\r\n\r\n- [ ] 3.9.0 beta1\r\n- [x] 3.8.0\r\n- [ ] Other: ___\r\n\r\n#### I have also:\r\n\r\n- [x] Tried out the nightly version: https://github.com/sqlitebrowser/sqlitebrowser#windows\r\n- [ ] Searched for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/comments/240060009","html_url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/731#issuecomment-240060009","issue_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/731","id":240060009,"user":{"login":"justinclift","id":406299,"avatar_url":"https://avatars.githubusercontent.com/u/406299?v=3","gravatar_id":"","url":"https://api.github.com/users/justinclift","html_url":"https://github.com/justinclift","followers_url":"https://api.github.com/users/justinclift/followers","following_url":"https://api.github.com/users/justinclift/following{/other_user}","gists_url":"https://api.github.com/users/justinclift/gists{/gist_id}","starred_url":"https://api.github.com/users/justinclift/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/justinclift/subscriptions","organizations_url":"https://api.github.com/users/justinclift/orgs","repos_url":"https://api.github.com/users/justinclift/repos","events_url":"https://api.github.com/users/justinclift/events{/privacy}","received_events_url":"https://api.github.com/users/justinclift/received_events","type":"User","site_admin":false},"created_at":"2016-08-16T10:03:12Z","updated_at":"2016-08-16T10:03:12Z","body":"Thanks Chris. :smile:\r\n\r\nThe original screencast URL wasn't working for me at first yesterday, but seems to be now.  So, the new ones will probably be workable too.\r\n\r\nI'll try them out in a bit, I just need to finish some other things first. :smile:"}}
{"actor":{"display_login":"justinclift"}}