UPPER function doesn't work anymore

[Peter Feibert]

I am using W2K and MySQl 5.0.11.

Since I upgraded from 5.0.4 (or something like that) MySQL's UPPER function no longer UPPERs my data. I pass it via IN parameters to my stored proc, then I TRIM and UPPER the data, llike so:

MYSTOREDPROC(in pphocode char(3))
begin
...
set pphocode = UPPER(TRIM(pphocode));
...
end;

What happens? The data when in lower case stays lower. When upper it stays upper. But I need it to be UPPER always.

What's happening?

Thanks,

Peter Feibert