fix collation in reporting queries