Last modified: 2007-06-20 18:01:44 UTC
Reported by Timonator on irc: pg_query() [function.pg-query]: Query failed: ERROR: invalid byte sequence for encoding "UTF8": 0x9a HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding". in ./includes/DatabasePostgres.php on line 389 A database error has occurred Query: SELECT math_outputhash,math_html_conservativeness,math_html,math_mathml FROM math WHERE math_inputhash = 'zfsq`X��y���.�V ' LIMIT 1 Function: MathRenderer::_recall Error: 1 ERROR: invalid byte sequence for encoding "UTF8": 0x9a HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encodin This is caused by pack() used to store the md5 hash as a binary field in the database.
remove the pack and unpack and it works, why pack at all? A md5 sum should always work. to me this looks like a useless operation while it might act as compression.
else use a bytea data type
While I agree the pack and unpack seems a little silly to save a few characters, I've changed the two database fields to bytea for now: r20542
*** Bug 9546 has been marked as a duplicate of this bug. ***
*** Bug 10321 has been marked as a duplicate of this bug. ***