String will be truncated

Guest User

5y776

Hi Team

Any mate who can advice me, i am running this query, somehow i am getting an exception 'Line 2'

insert into dbo.TrainingAcademy_Courses(CourseNo, Price, Venue, CourseDetails, Description, ZoomUrl, Url, CourseInstructor)
values(1, 3400.00, 'Online Virtual Event', 'Basic Measurement Course', '11 & 12 November 2020', 'Upcoming Training Event.jpg',
'Upcoming Training Event.jpg', 'Emorgin Van Heerden');

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
change description to varchar(Max) and url to nvarchar(50)
clearly your url is not fixed length of 10, so you can't use nchar(10)
Guest User5y ago
Thanks mate, its working
Jignesh Kumar5y ago
Hi Gcobani Mkontwana,

Here you are trying to insert value for Url field more then url field length that is the reason for this error.
Please use this code to change lentgh of your require columns, Below query is for 2 colimns ZoomUrl and Url to change length of column.
-- Increase lenth for ZoomUrl column
ALTER TABLE TrainingAcademy_Courses
alter COLUMN ZoomUrl nvarchar(500) null;

-- Increase lenth for Url column
ALTER TABLE TrainingAcademy_Courses
alter COLUMN Url nvarchar(500) null;

insert into dbo.TrainingAcademy_Courses(CourseNo, Price, Venue, CourseDetails, Description, ZoomUrl, Url, CourseInstructor)
values(1, 3400.00, 'Online Virtual Event', 'Basic Measurement Course', N'11 & 12 November 2020', 'Upcoming Training Event.jpg',
'Upcoming Training Event.jpg', 'Emorgin Van Heerden');
Mageshwaran R5y ago
Hi Gcobani,
Please try this query:
insert into dbo.TrainingAcademy_Courses(CourseNo, Price, Venue, CourseDetails, Description, ZoomUrl, Url, CourseInstructor)
values(1, 3400.00, 'Online Virtual Event', 'Basic Measurement Course', N'11 & 12 November 2020', 'Upcoming Training Event.jpg',
'Upcoming Training Event.jpg', 'Emorgin Van Heerden');
Guest User5y ago
Please check my attached db schema for these records
Sachin Singh5y ago
check your price column, it must be decimal
and all other column except primary key column looks like varchar(250)