Subject Re: UTF-8 vs UTF-16
Author mailmur
> > And then simple queries like:
> > Select * From table Where mystrcol = "Könkkä"
> >
> > Should play well with the charset defined in
> > without extra collaction syntax in a query.
> What are you doing? These queries do work right for me
> any time.

Yep, you are right. I had a problem here with a small program running
against MSSQL server. I tested it once against FB but it failed.

It was due to an uppercase function not working for international
characters. If query had "where upper(col1)='<value>'" it produced
problems. Sometimes it worked, but not always.

Then I found out COLLATE keyword for SELECT queries and tried it in
every way. I was not familiar with UNICODE_FSS and other explicit set
charsets at that time, but probably none workaround had work 100%.