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
_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
