{"action":"created","issue":{"url":"https://api.github.com/repos/npgsql/npgsql/issues/266","labels_url":"https://api.github.com/repos/npgsql/npgsql/issues/266/labels{/name}","comments_url":"https://api.github.com/repos/npgsql/npgsql/issues/266/comments","events_url":"https://api.github.com/repos/npgsql/npgsql/issues/266/events","html_url":"https://github.com/npgsql/npgsql/issues/266","id":37142412,"number":266,"title":"Currency symbol missing","user":{"login":"pkfox","id":1829732,"avatar_url":"https://avatars.githubusercontent.com/u/1829732?v=3","gravatar_id":"","url":"https://api.github.com/users/pkfox","html_url":"https://github.com/pkfox","followers_url":"https://api.github.com/users/pkfox/followers","following_url":"https://api.github.com/users/pkfox/following{/other_user}","gists_url":"https://api.github.com/users/pkfox/gists{/gist_id}","starred_url":"https://api.github.com/users/pkfox/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pkfox/subscriptions","organizations_url":"https://api.github.com/users/pkfox/orgs","repos_url":"https://api.github.com/users/pkfox/repos","events_url":"https://api.github.com/users/pkfox/events{/privacy}","received_events_url":"https://api.github.com/users/pkfox/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/npgsql/npgsql/labels/bug","name":"bug","color":"e11d21"}],"state":"closed","locked":false,"assignee":{"login":"roji","id":1862641,"avatar_url":"https://avatars.githubusercontent.com/u/1862641?v=3","gravatar_id":"","url":"https://api.github.com/users/roji","html_url":"https://github.com/roji","followers_url":"https://api.github.com/users/roji/followers","following_url":"https://api.github.com/users/roji/following{/other_user}","gists_url":"https://api.github.com/users/roji/gists{/gist_id}","starred_url":"https://api.github.com/users/roji/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/roji/subscriptions","organizations_url":"https://api.github.com/users/roji/orgs","repos_url":"https://api.github.com/users/roji/repos","events_url":"https://api.github.com/users/roji/events{/privacy}","received_events_url":"https://api.github.com/users/roji/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/npgsql/npgsql/milestones/3","labels_url":"https://api.github.com/repos/npgsql/npgsql/milestones/3/labels","id":620657,"number":3,"title":"3.0","description":"","creator":{"login":"franciscojunior","id":829924,"avatar_url":"https://avatars.githubusercontent.com/u/829924?v=3","gravatar_id":"","url":"https://api.github.com/users/franciscojunior","html_url":"https://github.com/franciscojunior","followers_url":"https://api.github.com/users/franciscojunior/followers","following_url":"https://api.github.com/users/franciscojunior/following{/other_user}","gists_url":"https://api.github.com/users/franciscojunior/gists{/gist_id}","starred_url":"https://api.github.com/users/franciscojunior/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/franciscojunior/subscriptions","organizations_url":"https://api.github.com/users/franciscojunior/orgs","repos_url":"https://api.github.com/users/franciscojunior/repos","events_url":"https://api.github.com/users/franciscojunior/events{/privacy}","received_events_url":"https://api.github.com/users/franciscojunior/received_events","type":"User","site_admin":false},"open_issues":37,"closed_issues":24,"state":"open","created_at":"2014-04-04T16:37:19Z","updated_at":"2015-01-13T20:04:19Z","due_on":null,"closed_at":null},"comments":17,"created_at":"2014-07-04T05:11:29Z","updated_at":"2015-01-13T20:08:06Z","closed_at":"2015-01-13T09:48:49Z","body":"Selecting a numeric field and formatting as text fails to return the currency symbol with this format string.\r\n\r\nExample postgres query\r\n\r\nSelect to_char(100.99,'FML999,999.00')  in PgAdmin and psql outputs £100.00 ( in the UK ) , but the symbol £ coming through as a blank space ( which to me indicates an encoding problem ) in DOTNET DataTable - however if using Postgres ODBC driver the symbol comes through fine.\r\n"},"comment":{"url":"https://api.github.com/repos/npgsql/npgsql/issues/comments/69810479","html_url":"https://github.com/npgsql/npgsql/issues/266#issuecomment-69810479","issue_url":"https://api.github.com/repos/npgsql/npgsql/issues/266","id":69810479,"user":{"login":"Emill","id":1660778,"avatar_url":"https://avatars.githubusercontent.com/u/1660778?v=3","gravatar_id":"","url":"https://api.github.com/users/Emill","html_url":"https://github.com/Emill","followers_url":"https://api.github.com/users/Emill/followers","following_url":"https://api.github.com/users/Emill/following{/other_user}","gists_url":"https://api.github.com/users/Emill/gists{/gist_id}","starred_url":"https://api.github.com/users/Emill/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Emill/subscriptions","organizations_url":"https://api.github.com/users/Emill/orgs","repos_url":"https://api.github.com/users/Emill/repos","events_url":"https://api.github.com/users/Emill/events{/privacy}","received_events_url":"https://api.github.com/users/Emill/received_events","type":"User","site_admin":false},"created_at":"2015-01-13T20:08:06Z","updated_at":"2015-01-13T20:08:06Z","body":"The monetary setting lc_monetary also affects binary read/write, since it tells how many digits should be the fraction part. While I agree this is kind of broken by design that the actual value of the number should depend on a runtime parameter, we could read the lc_monetary setting. But since this is just a string of the name of the language/country (that depends on operating system), it's quite hard to figure out how many digits to use.\r\n\r\nSince money is classified as an obsolete data type that still exists for backwards-compatibility, and most countries (I think?) use 2 decimals, we should probably just assume it is 2 decimals. That is what we do currently anyway by setting locale to C."}}