MySQL Forums
Forum List  »  InnoDB

Data too long for column 'vdisuser' at row 1
Posted by: Colin Millard
Date: June 14, 2021 03:44PM

All

Everything was running along smoothly, then I started to get an odd error message
'Data too long for column 'vdisuser' at row 1'

Table Structure is
CREATE TABLE `vdisuser` (
`id` int NOT NULL AUTO_INCREMENT,
`Username` varchar(45) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=' ';


Stored procedure is:-
CREATE DEFINER=`root`@`localhost` PROCEDURE `spInsertVDISUser`(IN vdisuser char)
BEGIN
Insert into vdisuser
(username)
value
(vdisuser);

END

Example call
call spInsertVDISUser('ColinTest');

Error Message is:-
'Data too long for column 'vdisuser' at row 1'

Has Something has changed in the settings ?

Could use some help here !

Options: ReplyQuote


Subject
Views
Written By
Posted
Data too long for column 'vdisuser' at row 1
143
June 14, 2021 03:44PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.