I'm having a problem with a form which is giving the following error on insert
of text fields which contain a paragraph or two of data.
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]String or binary data would be
truncated.
This error would seem
:47 PM
To: CF-Talk
Subject: binary data would be truncated
I'm having a problem with a form which is giving the following error on
insert of text fields which contain a paragraph or two of data.
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]String
On SQL Server NVARCHAR can be up to 4000. Just do a Len() in the data to see
if it is as long as you think it is.
Adrian
-Original Message-
From: [EMAIL PROTECTED]
Sent: 17 March 2008 18:01
To: CF-Talk
Subject: RE: binary data would be truncated
Nvarchar only allows 255 characters
or binary data would be
truncated.
This error would seem to me to be created by a MSSQL datatype which is not
large enough to hold the inserted data.
I was using nvarchar and have since switched to ntext which seems to have
fixed the problem.
I'm a bit confused as to why nvarchar was causing the error
I received this message (String or binary data would be truncated) while trying to open a file through a website.Any idea what could be causing this error?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
or binary data would be truncated.I received this message (String or binary data would be truncated) while trying to open a file through a website.Any idea what could be causing this error?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Check the data type in the database. If it's (N)Varchar check the length ofthe field. Rick -Original Message-From: Richard Crawford [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2003 6:27 PMTo: CF-TalkSubject: String or binary data would be truncated. I received this message
Any one ever see this error in the browser, then copy and past the same
query in ISQLW and it works fine for an insert. Does not make sense and
I am baffled. I have checked the field types and lengths so many times
now I remember them all. The only thing I can think of is one of the
strings might
Not to sound dumb my Florida friend, did you check the maxlengths of your form fields?
-Original Message-
From: Dan O'Keefe [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 9:06 AM
To: CF-Talk
Subject: SQL - String or binary data would be truncated.
Any one ever see this error
Is a Mac IE browser giving the issue?
- Calvin
- Original Message -
From: Dan O'Keefe [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 10:05 AM
Subject: SQL - String or binary data would be truncated.
Any one ever see this error in the browser, then copy
=== Previous Message Below ===
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 10:07 AM
To: CF-Talk
Subject: RE: SQL - String or binary data would be truncated.
Not to sound dumb my Florida friend, did you check
PROTECTED]
Sent: Thursday, June 26, 2003 10:13 AM
To: CF-Talk
Subject: Re: SQL - String or binary data would be truncated.
Is a Mac IE browser giving the issue?
- Calvin
- Original Message -
From: Dan O'Keefe [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, June 26, 2003
26, 2003 15:40
To: CF-Talk
Subject: RE: SQL - String or binary data would be truncated.
No, IE. I don't think it is the browser, but MSSQL itself. I have never seen
before where a CF submitted query not work consistently with the query
submitted via ISQLW.
Dan
=== Previous Message
13 matches
Mail list logo