[DC-675] Doctrine_Connection_Mssql charset problem Created: 10/May/10 Updated: 23/Jul/14 Resolved: 08/Jun/10
|Reporter:||Steve Müller||Assignee:||Jonathan H. Wage|
Recently I got problems with converting UTF-8 data to iso ISO-8859-1 while trying to insert/update a Microsoft SQL Server database.
SQLSTATE[HY000]: General error: trying to execute an empty query
As i tracked the error down I realized, that the exception only occurs if I try to insert/update data with special characters like "ü", "ö", "ä", "ß" etc.
RESULTING DQL: UPDATE table SET zip = ?, city = ?, street = ? WHERE id = ?;
After replaceBoundParamsWithInlineValuesInQuery() replaces param 'München', the query string is replaced by an empty string in the following iteration.
The root of the Problem seems to lie in the regex modifier 'u' which treats the pattern as UTF-8 in the param replacements. Removing this modifier solves the problem for me. What purpose has this modifier?