Hello, I can't find how to do a comparison ignoring case, currently my code inside a `find()` is `Ac...

# exposed

[Marcin Wisniowski]

Hello, I can't find how to do a comparison ignoring case, currently my code inside a find() is Accounts.character eq character. How do I make this case insensitive?

[tapac]

In many databases comparison is based on column collation. E.g. in MySQL all collations ending on _ci works in Case Insensitive way.

However, you may compare it in that way:
Accounts.character.lowerCase() eq character.toLowerCase()

[Marcin Wisniowski]

Ohh, all right, thank you.