Cyrillic problem in func.lower in SQLAlechemy
In Cyrillic, func.lower is processed in SQLAlchemy with an error.
Sample code:
category_in_db = db.session…query(Category)…filter_by(user_id=user_id)
…filter(func.lower(Category.name, type_=String) == category_name.lower())…first()
Two expressions are compared. Let’s say there is a value in the database Dream… If it is of such a plan, when capital letters are saved in the database, then when comparing Sleep == sleep… They will not be equal to each other.
What to do? Enter with a lowercase letter if comparisons in Cyrillic are required. I did not find any other options. You can of course make super-crutches and compare with all values, but this is crazy.
