AMC LOG Table

[Anonymous]

Hi Team

i am using AMC log table Creation I have created my log table as per below schema

CREATE TABLE `amclogdata` (
  `moment` datetime DEFAULT NULL,
  `pid` varchar(20) DEFAULT NULL,
  `root_pid` varchar(20) DEFAULT NULL,
  `father_pid` varchar(20) DEFAULT NULL,
  `project` varchar(50) DEFAULT NULL,
  `job` varchar(255) DEFAULT NULL,
  `context` varchar(50) DEFAULT NULL,
  `priority` int(3) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `origin` varchar(255) DEFAULT NULL,
  `message` varchar(255) DEFAULT NULL,
  `code` int(3) DEFAULT NULL
);

But the  message is too large so that record is not inserting into the table and i am getting db truncation issue how to solve this.PLease suggest.

Thanks

Deepthi

[Anonymous]

Have you tried rebuilding your log table with the message column resized to something a bit larger? Also, are you sizing in chars or bytes? Are the characters you are using multi byte?