Limitations of item.lastvalue

[yaap]

Hi,

I have defined item as Text (Type of information) because value could be longer then 255 chars.
Lastvalue field in item table is defined as varchar(255). I have found out that's why lastvalue is trimmed to 255 chars.

What is the way to get the whole lastvalue of item through Zabbix API.
What will be the impact on Zabbix if I change item.lastvalue, item.prevvalue definition to "TEXT" type ?

--
Regards
yaap

[yaap]

Mysql documentation says:
http://dev.mysql.com/doc/refman/5.0/en/char.html

Values in VARCHAR columns are variable-length strings.
The length can be specified as a value from 0 to 255 before MySQL 5.0.3, and 0 to 65,535 in 5.0.3 and later versions.

What will happen if I increase lastvalue field size to 1024 ?

[yaap]

Mysql documentation says:
http://dev.mysql.com/doc/refman/5.0/en/char.html



What will happen if I increase lastvalue field size to 1024 ?

Temporary workaround uses dedicated method called 'item.lastvalue' which gets lastest value from history.