2012-08-12, 14:20
(2012-08-12, 09:19)Montellese Wrote:(2012-08-11, 19:47)Tolriq Wrote: I finally got the database and it seems that's it the data in database that is not good and I suppose the json part suppose the data is correct UTF and does not do another utf encodeIn general XBMC should store everything as UTF8. If it doesn't the problem is somewhere else in XBMC and could also cause problems in the GUI when displaying the text.
How is non valid UTF be stored in database ? If this can happens shouldn't the Json part ensure that it sends correct data ?
A screen shot of the database content : http://yatse.leetzone.org/Images/utf.png
Another possibility is if a user manually changed stuff in the database (e.g. fixed a movie plot or something like that). Then it's no longer garantueed that the text is correctly encoded in UTF8 but that's the problem of the user manually editing the database or using a third party tool that writes directly to the XBMC database and messes up the encoding.
I just got feedback from this user and he did not tamper the database, he just use NFO files then Xbmc scan.
The Nfo files are effectively badly encoded but Xbmc should sanitize those and not insert in database incorrect data.
http://yatse.leetzone.org/Castle.S03E01.nfo / http://yatse.leetzone.org/Castle.S03E02.nfo