Dear Knights of the Flaming Bird!

In my program I'm sometimes using a case insensitive search function
for specified columns.

In SQL: where upper(col1) like upper('mysearchstring%')

The db charset is UNICODE_FSS

My problem is the hungarian characters don't uppercase properly, which
is as expected after some searching and reading. And I also see there
is no hungarian collation for unicode

So my question is: is there any way to convert a column's varchar
charset to iso8859_2 in runtime? Or any other way I could get
hungarian characters to uppercase in runtime?
Or do I need to change the column's charset permanently? (which is
the last thing I'd like to do)

Thank you,
John