mysql> SELECT TABLE_SCHEMA,
TABLE_NAME, COLUMN_NAME, DATA_TYPE FROM columns WHERE
DATA_TYPE IN ('text', 'blob') AND TABLE_SCHEMA =
'observium';
+--------------+------------------+-----------------------+-----------+
| TABLE_SCHEMA | TABLE_NAME
| COLUMN_NAME | DATA_TYPE |
+--------------+------------------+-----------------------+-----------+
| observium | alert_assoc
| device_attribs | text |
| observium | alert_assoc
| entity_attribs | text |
| observium | alert_log
| message | text |
| observium | alert_tests
| alert_message | text |
| observium | alert_tests
| conditions | text |
| observium | alerts
| message | text |
| observium | authlog
| user | text |
| observium | authlog
| address | text |
| observium | authlog
| result | text |
| observium | bgpPeers
| bgpPeerState | text |
| observium | bgpPeers
| bgpPeerAdminStatus | text |
| observium | bill_history
| bill_type | text |
| observium | bills
| bill_name | text |
| observium | bills
| bill_type | text |
| observium | config
| config_value | text |
| observium | devices
| sysDescr | text |
| observium | devices
| sysContact | text |
| observium | devices
| version | text |
| observium | devices
| hardware | text |
| observium | devices
| features | text |
| observium | devices
| location | text |
| observium | devices
| device_state | text |
| observium | devices_attribs
| attrib_value | text |
| observium | eigrp_ports
| eigrp_authmode | text |
| observium | entPhysical
| entPhysicalDescr | text |
| observium | entPhysical
| entPhysicalClass | text |
| observium | entPhysical
| entPhysicalName | text |
| observium | entPhysical
| entPhysicalModelName | text |
| observium | entPhysical
| entPhysicalVendorType | text |
| observium | entPhysical
| entPhysicalSerialNum | text |
| observium | entPhysical
| entPhysicalMfgName | text |
| observium | eventlog
| message | text |
| observium | groups_assoc
| device_attribs | text |
| observium | groups_assoc
| entity_attribs | text |
| observium | hrDevice
| hrDeviceDescr | text |
| observium | hrDevice
| hrDeviceType | text |
| observium | hrDevice
| hrDeviceStatus | text |
| observium | munin_plugins
| mplug_info | text |
| observium | munin_plugins_ds
| ds_extinfo | text |
| observium | munin_plugins_ds
| ds_sum | text |
| observium | munin_plugins_ds
| ds_stack | text |
| observium | services
| service_ip | text |
| observium | services
| service_desc | text |
| observium | services
| service_param | text |
| observium | services
| service_message | text |
| observium | storage
| storage_descr | text |
| observium | syslog
| msg | text |
| observium | users
| user_options | text |
| observium | vrfs
| mplsVpnVrfDescription | text |
+--------------+------------------+-----------------------+-----------+
49 rows in set (0.04 sec)