Warning with show variables

[Olag Ulga]

Hi

On some of our servers MySql displays a warning if i execute the query >show variables<

The Warning Incorrect string value: '\xE4ische...' for column 'Value' at row 1

even if i filter the query like >show variables where variable_name = 'xxxx'< so that no rows are returnd the warning occurs.

The servers are running on Windows
No Warning on. MySql 5.0.27
Warning on 5.0.45, 5.0.77, 5.0.87

The servers are not running the exactly same config. So it could also be a config thing.

>>>Where is this Warning from and how can I prevent it?


Thanks for help...



Update:
I have found a possible reason. The following row is truncated even on 5.0.27: 'system_time_zone', 'Mitteleurop'

combined with '\xE4ische...' it results in Mitteleuropäische...

>>>>Is it an encoding bug or a config mistake?



Edited 1 time(s). Last edit at 11/19/2009 02:18AM by Olag Ulga.