{"action":"created","issue":{"url":"https://api.github.com/repos/Gnurou/tagainijisho/issues/157","labels_url":"https://api.github.com/repos/Gnurou/tagainijisho/issues/157/labels{/name}","comments_url":"https://api.github.com/repos/Gnurou/tagainijisho/issues/157/comments","events_url":"https://api.github.com/repos/Gnurou/tagainijisho/issues/157/events","html_url":"https://github.com/Gnurou/tagainijisho/issues/157","id":124581716,"number":157,"title":"Search bar automatically capitalizes first word; changes the whole search results","user":{"login":"utsubushi621","id":16515092,"avatar_url":"https://avatars.githubusercontent.com/u/16515092?v=3","gravatar_id":"","url":"https://api.github.com/users/utsubushi621","html_url":"https://github.com/utsubushi621","followers_url":"https://api.github.com/users/utsubushi621/followers","following_url":"https://api.github.com/users/utsubushi621/following{/other_user}","gists_url":"https://api.github.com/users/utsubushi621/gists{/gist_id}","starred_url":"https://api.github.com/users/utsubushi621/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/utsubushi621/subscriptions","organizations_url":"https://api.github.com/users/utsubushi621/orgs","repos_url":"https://api.github.com/users/utsubushi621/repos","events_url":"https://api.github.com/users/utsubushi621/events{/privacy}","received_events_url":"https://api.github.com/users/utsubushi621/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/Gnurou/tagainijisho/milestones/6","html_url":"https://github.com/Gnurou/tagainijisho/milestones/1.0.4","labels_url":"https://api.github.com/repos/Gnurou/tagainijisho/milestones/6/labels","id":1108024,"number":6,"title":"1.0.4","description":null,"creator":{"login":"Gnurou","id":148255,"avatar_url":"https://avatars.githubusercontent.com/u/148255?v=3","gravatar_id":"","url":"https://api.github.com/users/Gnurou","html_url":"https://github.com/Gnurou","followers_url":"https://api.github.com/users/Gnurou/followers","following_url":"https://api.github.com/users/Gnurou/following{/other_user}","gists_url":"https://api.github.com/users/Gnurou/gists{/gist_id}","starred_url":"https://api.github.com/users/Gnurou/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Gnurou/subscriptions","organizations_url":"https://api.github.com/users/Gnurou/orgs","repos_url":"https://api.github.com/users/Gnurou/repos","events_url":"https://api.github.com/users/Gnurou/events{/privacy}","received_events_url":"https://api.github.com/users/Gnurou/received_events","type":"User","site_admin":false},"open_issues":4,"closed_issues":0,"state":"open","created_at":"2015-05-13T06:07:16Z","updated_at":"2016-01-05T21:28:05Z","due_on":null,"closed_at":null},"comments":3,"created_at":"2016-01-02T08:59:52Z","updated_at":"2016-01-06T00:26:05Z","closed_at":null,"body":"I tried searching for a word by using Romaji. My example was typing \"Ame\" with a capital A. This only gave me 2 Results under the \"All\" Category. When I typed it in all lower case (ame), I finally got what I wanted which were all the words that are spelled containing ame. When I click any of the objects in the search results, the search bar automatically corrects or capitalizes the word from \"ame\" to \"Ame,\" taking me back to the problem that only 2 objects are shown in the search results. This is a problem because I can't even scroll down through the list for the search results for \"ame\" which there are many. I can't see them because of this problem, since clicking outside of the search bar immediately \"corrects\" the search keyword by capitalizing. I love the program so far, I love it so much I really want to study Japanese and this program is just what I need to ease that, so if this problem would get resolved I would very much appreciate it, I think it shouldn't be too hard even though I'm not a programmer I hope it isn't hard to fix. Thanks"},"comment":{"url":"https://api.github.com/repos/Gnurou/tagainijisho/issues/comments/169177398","html_url":"https://github.com/Gnurou/tagainijisho/issues/157#issuecomment-169177398","issue_url":"https://api.github.com/repos/Gnurou/tagainijisho/issues/157","id":169177398,"user":{"login":"firatakandere","id":2188474,"avatar_url":"https://avatars.githubusercontent.com/u/2188474?v=3","gravatar_id":"","url":"https://api.github.com/users/firatakandere","html_url":"https://github.com/firatakandere","followers_url":"https://api.github.com/users/firatakandere/followers","following_url":"https://api.github.com/users/firatakandere/following{/other_user}","gists_url":"https://api.github.com/users/firatakandere/gists{/gist_id}","starred_url":"https://api.github.com/users/firatakandere/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/firatakandere/subscriptions","organizations_url":"https://api.github.com/users/firatakandere/orgs","repos_url":"https://api.github.com/users/firatakandere/repos","events_url":"https://api.github.com/users/firatakandere/events{/privacy}","received_events_url":"https://api.github.com/users/firatakandere/received_events","type":"User","site_admin":false},"created_at":"2016-01-06T00:26:05Z","updated_at":"2016-01-06T00:26:05Z","body":"I \"sometimes\" have the same autocorrect issue, I have just realized it and I'm still trying to figure it out why.\r\n\r\nI think uncapitaling the search terms would not work well since there are capital letters in the database entries.\r\n\r\nAdding `collate nocase` to the select query may help, or better you may want to specify `collate nocase` in the column definition which takes the lowercase versions of values when a comparison is performed. Second option is said to be working faster.\r\n\r\nhttp://www.sqlite.org/datatype3.html#collation"}}