{"comment":{"created_at":"2011-10-11T08:15:03Z","body":"[springmeyer] great, I fixed the db in r3317, and applied your patch in r3318. Great to see that this was basically now working but just the data was wrong. closing.","updated_at":"2011-10-11T08:15:03Z","url":"https://api.github.com/repos/mapnik-org/mapnik/issues/comments/2358773","id":2358773,"user":{"avatar_url":"https://secure.gravatar.com/avatar/941f68386168a8a6b60f2529a7830af7?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","url":"https://api.github.com/users/artemp","id":59056,"login":"artemp"}},"action":"created","issue":{"number":870,"created_at":"2011-10-11T08:15:01Z","pull_request":{"diff_url":null,"patch_url":null,"html_url":null},"body":"before r3191 we were seeing undefined behavior with some string fields ending up leading to scrambled results with truncated field names and field values being returned from sqlite.\r\n\r\nI thought the problem was fixed by doing:\r\n\r\n{{{\r\nint text_size; \r\nconst char * data = rs_->column_text(i,text_size); \r\nUnicodeString ustr = tr_->transcode(data,text_size); \r\nboost::put(*feature,fld_name,ustr); \r\n}}}\r\n\r\ninstead of:\r\n\r\n{{{\r\nconst char * data = rs_->column_text(i); \r\nUnicodeString ustr = tr_->transcode(data); \r\nboost::put(*feature,fld_name,ustr); \r\n}}}\r\n\r\nBut that appears to lead to bogus `[]` junk at the end of some text strings, notably the `tests/data/good_maps/text_rotation.xml` test.","comments":3,"title":"sqlite: unicode string handling","updated_at":"2011-10-11T08:15:03Z","url":"https://api.github.com/repos/mapnik-org/mapnik/issues/870","id":1872580,"assignee":null,"milestone":null,"closed_at":null,"user":{"avatar_url":"https://secure.gravatar.com/avatar/941f68386168a8a6b60f2529a7830af7?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","url":"https://api.github.com/users/artemp","id":59056,"login":"artemp"},"html_url":"https://github.com/mapnik-org/mapnik/issues/870","labels":[{"name":"Core_Library","url":"https://api.github.com/repos/mapnik-org/mapnik/labels/Core_Library","color":"FFFFFF"}],"state":"open"},"legacy":{"issue_id":1872580,"comment_id":2358773}}