Transliteral search?

Question

PostgreSQL

The table has name = A101etc.
How would it be more correct to make this string searched both as English and as Russian "A"?

Now, in general, the search goes through ilike:
select * from rooms where name ilike %?%

Answer 1

Write the transliteration in the next column, index and search in two columns.

Answer 2

SELECT * FROM rooms WHERE name = 'A101' OR name = 'А101'

Or create a table of options, then it will find and A1О1', AI01'and so on.