Error al postear con urls con caracteres UNICODE

He ido a enviar un MP con esta url Imagen y me salta con esto:

SQL ERROR [ mysqli ]

Incorrect string value: '\xC5 ... ...' for column 'message_text' at row 1 [1366]

SQL

UPDATE privmsgs SET message_edit_count = message_edit_count + 1, icon_id = 0, message_edit_time = 1290276700, enable_bbcode = 1, enable_smilies = 1, enable_magic_url = 1, enable_sig = 1, message_subject = 'Re: Tu avatar', message_text = 'Parece que ha gustado bastante <!-- sXD --><img src=\"{SMILIES_PATH}/biggrin.gif\" alt=\"XD\" title=\"partiéndose\" /><!-- sXD --> \n\nOre no Imōto ga Konna ni Kawaii Wake ga Nai &lt;- así se llama la serie\n\n<!-- m --><a class=\"postlink\" href=\"http://en.wikipedia.org/wiki/Ore_no_Imōto_ga_Konna_ni_Kawaii_Wake_ga_Nai\">http://en.wikipedia.org/wiki/Ore_no_Im� ... ake_ga_Nai</a><!-- m -->', message_attachment = 0, bbcode_bitfield = '', bbcode_uid = '3pctd0bx' WHERE msg_id = 3337443

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 161
CALL: dbal->sql_error()

FILE: includes/functions_privmsgs.php
LINE: 1441
CALL: dbal_mysqli->sql_query()

FILE: includes/ucp/ucp_pm_compose.php
LINE: 746
CALL: submit_pm()

FILE: includes/ucp/ucp_pm.php
LINE: 126
CALL: compose_pm()

FILE: includes/functions_module.php
LINE: 507
CALL: ucp_pm->main()

FILE: ucp.php
LINE: 363
CALL: p_master->load_active()


He tenido que capturar la url en una imagen si no es imposible.
.
melado, fix it XD
1 respuesta