Data too long for column 'vdisuser' at row 1
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 !
Subject
Views
Written By
Posted
Data too long for column 'vdisuser' at row 1
714
June 14, 2021 03:44PM
317
June 14, 2021 04:38PM
Sorry, you can't reply to this topic. It has been closed.
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.