All strings are encoded using the character set uft8mb4. Hence, it is possible to store all kind of characters - including emojis - in this type of fields.
When comparing and sorting fields of this type the system considers upper case characters to be distinctly different from lower case characters. Furthermore, characters with any kind of accent is considered distinctly different from the same character without the accent.
- The string ‘TEST’ is not equal to the string ‘Test’.
- The string ‘Cotê’ is not equal to the string ‘Cote’.