Subject Re: Euro characters and UPPER
Author Svein Erling Tysvær
--- In, "georgethenorge" wrote:
> I tried the _iso8859_1 in front of the string, but the øæå was just
> a simple example. I need to have a field there that will be
> converted to uppercase.
> But this is the important question: If I create a database with say
> ISO8859_1, then will UPPER work with Euro characters?

No, for UPPER to function you also have to specify the collation (as I
tried to illustrate when my Norwegian characters got all garbled up),
for the three Norwegian characters you should use COLLATE NO_NO.

Another thing is that I don't think ISO8859_1 has the euro sign, for
that I think you should use WIN1252. However, I don't know this
character set and have no idea about whether the collations have the
same names as the collations for ISO8859_1 or not.