I have a system where I need to compare bytea values ​​(case insensitive in this case). For this purpose, I use encode to convert the bytea values ​​into strings which I then compare. This works as long as there is no unicode character in the array.