Dear Developers

Due to a quite old bug #0012860 storing 4-Byte-Characters to the Database lead to losing data since MySQL just stripped away all text after such a character. Therefore the ILIAS society funded a filter in the database-layer which filters those characters and replace them with a „?“. The filter is only applied when using 

- ilDBInterface::insert();
- ilDBInterface::update();
- ilDBInterface::manipulate();
- ilDBInterface::manipulateF();
- ilDBInterface::query();
- ilDBInterface::queryF();

This fix now has been published in 5.2, 5.3 and trunk. You get this information because there are slight interface-changes (added methods in ilDBInterface). 
For details please have a look at:

This fix does not restore already corrupted data in the database since this is not possible. 

Best regards


Fabian Schmid
Member of the Executive Board
Head of Software Development

studer + raimann ag
IT- and Learning-Solutions
Farbweg 9
3400 Burgdorf

main +41 31 972 52 22
support +41 31 972 52 30
direct +41 31 972 52 27

Wanna know more? Contact us directly or find information online:
Corporate Website | Product Website  
Facebook | XING | LinkedIn