Home » Bugs » BUG 227 : MySql decrypt of Umlauts etc not working
 Bug 227 : MySql decrypt of Umlauts etc not working
Priority 
High
 Reported Version 
 
 Logged By 
Rob
Status 
Fixed
 Fixed Version 
2.5.0
 Assigned To 
 
Product 
Ebean - core
 Duplicate Of 
 
 Created 
01/03/2010
Updated 
01/03/2010
 Type 
Bug
  
Attachments 
No attachments

It appears that in MySql we need to include an explicit conversion to UTF8 as part of the decryption.
 
Rob 01 Mar 11:43
patch ... via Eddie.

public String getDecryptSql(String columnWithTableAlias) {
- return "AES_DECRYPT(" + columnWithTableAlias + ",?)";
+ return "CONVERT(AES_DECRYPT(" + columnWithTableAlias + ",?) USING UTF8)";
}

Rob 01 Mar 11:43
Fixed in HEAD

fixed in head.

woResponse

Upload a file