152: unicode characters problem

Notes
(212) Shahrooz (reporter) 2010-05-18 01:52	Source Control Integration 0.16.1 Subversion Integration 0.16

(223) Dennis Somerville (reporter) 2010-06-14 13:24	I get this same issue as well. I received when setting up a new repo and doing an "Import Everything". Database query failed. Error received from database was #1366: Incorrect string value: '\xD1OL' for column 'filename' at row 1 for the query: INSERT INTO mantis_plugin_Source_file_table ( change_id, revision, action, filename ) VALUES ( ?, ?, ?, ? ).

(236) Thijs Putman (reporter) 2010-08-09 06:33	Ran into the same issue; Mantis' DB abstraction layer doesn't seem to handle UTF-8 values that well in this situation... I applied a quick-and-dirty fix for this problem in SourceChangeset::save() (Source/Source.API.php), added: $message = iconv('ISO-8859-1', 'ASCII//TRANSLIT', $this->message); below "$t_changeset_table = ..." (line 860) Subsequently changed the two queries in the "save" method to utilise "$message" instead of "$this->message". The above "solution" simply transliterates the SVN commit message back to ASCII (attempting to replace all "special" characters with "regular" ones) before attempting to query the database. Might not be the best long-term solution, but seeing as how commit messages with non-ASCII content are a big exception in my set-up it suffices...

(257) obones (reporter) 2011-01-18 00:51	I believe this is a duplicate of 130

Relationships