error in sql query

[steff]

Hi All,

periodically the zabbix_server process exits due to unsupported characters in
the value fields of a sql query. I get this server log:

Query::select num,value_min,value_avg,value_max from trends where itemid=18181 and clock=1171875������`�

I have this problem since the 1.0beta12 zabbix version, now I'm using the 1.1.4-1 version of the debian package. My db is mysql with InnoDB tables.
I've already posted a thread explaining this problem (http://www.zabbix.org/forum/showthre...ighlight=query) but I still can't find a solution .
The only things I know are:

- is related to the value charset
- it is not related to a single item
- maybe it could be caused by something like db collation
- mysqlchecktables doesn't report any error

Thanks in advance for any support.

[Alexei]

Does it happen in random queries or in the only one?

[steff]

Yes in that only one query.
If you want I can provide you a snapshot of the data relative to that query.

Many thanks
steff