Alessandro wrote:
I'm trying to insert a new ticket from web and from mail that contain some strange (not for italian language) character and i receive strange error.
This is the error
[Wed Aug 30 18:43:25 2006][Error][Kernel::System::Ticket::TicketCreate][396] Data too long for column 'title' at row 1, SQL: 'INSERT INTO ticket (tn, title, create_time_unix, queue_id, ticket_lock_id, user_id, group_id, ticket_priority_id, ticket_state_id, ticket_answered, escalation_start_time, timeout, valid_id, create_time, create_by, change_time, change_by) VALUES ('2006083020000112', 'Titolo con caratteri è accentati', 1156956205, 2, 1, 1, 1, 3, 1, 0, 1156956205, 0, 1, current_timestamp, 1, current_timestamp, 1)'
The problem is à character in the title (but also è ò ù...), and i think that the error reported Data too long for column 'title' is not exact.
How can i resolve this problem?
(snip) It sounds like the problem is with the character set configuration in your MySQL. MySQL is expecting a character set which doesn't include those accented characters, and complains with the cryptic error message "data too long". More info here: http://dev.mysql.com/doc/refman/5.0/en/charset.html -- Jon