> <max.muster666@...> wrote:
>>
>> I have following statement :
>>
>> update utf_8_test set text = 'toll' where upper(text) = upper('ä'
>> collate utf8)
>>
>> 'ä' is utf8 coded : 'ä' and in hex : c384
>>
>> The question is now why i get this "Arithmetic owerflow or devision by
>> zero has occured" message ?
>>
>> Regards ,
>> max
>>

> sorry hex for 'ä' is c3a4
> the utf_8_test table is set to utf8 collate utf8.

What is the character set of your Client connection? If it is UTF8,
then you don't have to encode the UTF-8 stuff yourself.

Regards

Stefan