Originally Posted by rvindum
Seems the following command works:
mysql -u root -p -D mythconverg -E --default-character-set=utf8 -e "UPDATE recorded SET subtitle=REPLACE(subtitle, '\0', '');"
Found a discussions about this, where the error seemed to come frome the EIT and caused unsupported chars in the database.
Just tried it, and it seemed to work - don't know if the error returns after next recording, but time will tell.
Now thats really obscure. I'm supprised that mysql allows null characters to be passed in a field, unless the field is defined as a blob.
But glab to hear you fixed your problem.
Walking on water and writing software to specification is easy if they're frozen.
My corner of the internet http://www.planet-ian.com
Ubuntu Forums Code of Conduct