|Subject||Re: UTF-8 vs UTF-16|
> > And then simple queries like:column/table/database,
> > Select * From table Where mystrcol = "Könkkä"
> > Should play well with the charset defined in
> > without extra collaction syntax in a query.Yep, you are right. I had a problem here with a small program running
> What are you doing? These queries do work right for me
> any time.
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%.