{"action":"created","issue":{"url":"https://api.github.com/repos/geotools/geotools/issues/792","labels_url":"https://api.github.com/repos/geotools/geotools/issues/792/labels{/name}","comments_url":"https://api.github.com/repos/geotools/geotools/issues/792/comments","events_url":"https://api.github.com/repos/geotools/geotools/issues/792/events","html_url":"https://github.com/geotools/geotools/pull/792","id":63992812,"number":792,"title":"Added support for Nvarchar filtering in SQL Server","user":{"login":"mwronowski","id":11519358,"avatar_url":"https://avatars.githubusercontent.com/u/11519358?v=3","gravatar_id":"","url":"https://api.github.com/users/mwronowski","html_url":"https://github.com/mwronowski","followers_url":"https://api.github.com/users/mwronowski/followers","following_url":"https://api.github.com/users/mwronowski/following{/other_user}","gists_url":"https://api.github.com/users/mwronowski/gists{/gist_id}","starred_url":"https://api.github.com/users/mwronowski/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mwronowski/subscriptions","organizations_url":"https://api.github.com/users/mwronowski/orgs","repos_url":"https://api.github.com/users/mwronowski/repos","events_url":"https://api.github.com/users/mwronowski/events{/privacy}","received_events_url":"https://api.github.com/users/mwronowski/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-03-24T13:20:24Z","updated_at":"2015-08-27T07:09:04Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/geotools/geotools/pulls/792","html_url":"https://github.com/geotools/geotools/pull/792","diff_url":"https://github.com/geotools/geotools/pull/792.diff","patch_url":"https://github.com/geotools/geotools/pull/792.patch"},"body":"Change made because there was no option to filter SQL Server columns that contains special/national characters as a query generated by this SQL Server jdbc plugin was not using nvarchar type comparison with N' prefix. I think it is necesary to have nvarchar type of comparison because when using geotools in geoserver there is need to create complicated shapes, layers with different type of data and characters. Without this change GeoServer is useless for national data sets"},"comment":{"url":"https://api.github.com/repos/geotools/geotools/issues/comments/135316966","html_url":"https://github.com/geotools/geotools/pull/792#issuecomment-135316966","issue_url":"https://api.github.com/repos/geotools/geotools/issues/792","id":135316966,"user":{"login":"jodygarnett","id":629681,"avatar_url":"https://avatars.githubusercontent.com/u/629681?v=3","gravatar_id":"","url":"https://api.github.com/users/jodygarnett","html_url":"https://github.com/jodygarnett","followers_url":"https://api.github.com/users/jodygarnett/followers","following_url":"https://api.github.com/users/jodygarnett/following{/other_user}","gists_url":"https://api.github.com/users/jodygarnett/gists{/gist_id}","starred_url":"https://api.github.com/users/jodygarnett/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jodygarnett/subscriptions","organizations_url":"https://api.github.com/users/jodygarnett/orgs","repos_url":"https://api.github.com/users/jodygarnett/repos","events_url":"https://api.github.com/users/jodygarnett/events{/privacy}","received_events_url":"https://api.github.com/users/jodygarnett/received_events","type":"User","site_admin":false},"created_at":"2015-08-27T07:09:04Z","updated_at":"2015-08-27T07:09:04Z","body":"@mwronowski I am afraid this pull request is not being merged in time for the upcoming 14-beta. Not a lot of volunteers have access to SQL Server to test against.\r\n\r\n@ianturton you may be able to review this one? Not sure ..."}}