No announcements
Found 2855340 threads
-
13 VotesWhy are my VBA string format functions are not working?
This saved my life!Answered | 16 Replies | 105322 Views | Created by JDKunkel - Monday, September 13, 2010 1:56 PM | Last reply by lman252 - Monday, May 14, 2018 5:21 PM
-
0 Votes
NVARCHAR truncates when concatenating VARCHAR strings - why?
Enjoyed my post?Answered | 2 Replies | 2046 Views | Created by TheBrenda - Monday, May 9, 2016 3:23 PM | Last reply by Naomi N - Monday, May 9, 2016 5:47 PM -
0 Votes
How to truncate String?
Why do you need this?Answered | 3 Replies | 1221 Views | Created by chcw - Friday, January 29, 2016 9:37 AM | Last reply by Jingyang Li - Friday, January 29, 2016 9:52 PM -
0 Votes
string truncation on excuting sqlcommand
I think the string truncation error is caused by when needing ensure your parameters match the table column lengths.Answered | 1 Replies | 4115 Views | Created by fs - ab - Wednesday, June 15, 2011 4:25 AM | Last reply by Jackie-Sun - Friday, June 17, 2011 7:16 AM -
2 Votes
Query field values truncated
I found this while trying to find answer to my similar problem in my output.Answered | 4 Replies | 2732 Views | Created by Bill Hardin - Thursday, August 11, 2011 4:01 PM | Last reply by accessbob-pdx - Friday, October 23, 2015 11:46 AM -
0 Votes
String or binary data would be truncated.
My blogAnswered | 2 Replies | 4722 Views | Created by Night_devil - Wednesday, July 7, 2010 5:46 PM | Last reply by Naomi N - Wednesday, July 7, 2010 5:54 PM -
0 Votes
String or binary data would be truncated.
the problem comes from Microsoft SQL Server 2000 (fix it with sp4)... i dont kwon why still have a recurring problem (windows xp, vista , 7).Answered | 4 Replies | 4895 Views | Created by Developer_Usa - Monday, December 15, 2008 6:59 PM | Last reply by Marlon Gacia - Thursday, November 4, 2010 6:25 PM -
0 Votes
String or binary data would be truncated
Yep, that is long time problem , Erland has opened a connect for the ...Answered | 5 Replies | 1401 Views | Created by Y a h y a - Sunday, August 23, 2015 8:54 PM | Last reply by Uri Dimant - Monday, August 24, 2015 9:52 AM -
1 Votes
Why are leading 0s being truncated?
Hi ITBobbyP, After testing the issue in my environment, the package load data correctly into SQL Server table.Answered | 4 Replies | 875 Views | Created by ITBobbyP - Friday, September 25, 2015 2:55 PM | Last reply by Katherine Xiong - Monday, September 28, 2015 2:33 AM -
2 Votes
String or binary data would be truncated
You are storing the string 'Test...Test' that is 60 characters in length, so for this NVARCHAR column length should be minimum 120.Answered | 3 Replies | 5465 Views | Created by Muthukumar Rajendran - Saturday, November 20, 2010 8:57 AM | Last reply by Muthukumar Rajendran - Saturday, November 20, 2010 10:23 AM -
2 Votes
Is there a way to allow truncation and avoid "String or binary data would be truncated" error
I thought I was over-reacting when I set my datatype to varchar(8000) in my staging table!!!Answered | 7 Replies | 24227 Views | Created by imsam67 - Monday, July 11, 2011 7:28 PM | Last reply by imsam67 - Tuesday, July 12, 2011 12:32 AM -
0 Votes
A c++ dll manipulating a vba string
The solution depends on how you have declared this function in VBA.Answered | 3 Replies | 3006 Views | Created by SunnySaha - Tuesday, July 31, 2012 8:13 AM | Last reply by Renjith V Ramachandran - Tuesday, July 31, 2012 12:56 PM -
1 Votes
Automatic Truncate Long Strings while inserting data.
Application have to truncate extra characters.Answered | 8 Replies | 17544 Views | Created by AminMashayekhi - Sunday, March 1, 2009 9:17 AM | Last reply by Erland Sommarskog - Tuesday, March 17, 2020 10:26 PM -
0 Votes
A better error identification in terms of 'String or binary data would be truncated.' issues
My blog My TechNet articlesAnswered | 3 Replies | 2956 Views | Created by matsg2012 - Tuesday, January 31, 2012 6:57 PM | Last reply by Naomi N - Sunday, August 23, 2015 9:08 PM -
0 Votes
Why is VBA truncating my string
I don't know what makes you think your SQL string is being truncated, but I can tell you for sure that if you execute RunSQL with a SELECT query, you will get error 2342, "A ...Unanswered | 3 Replies | 909 Views | Created by PaulSchonenberger - Monday, March 27, 2017 2:32 PM | Last reply by AccessVandal - Tuesday, March 28, 2017 12:54 AM -
0 Votes
String or binary data would be truncated LinQ Insert
Hi, According to this Customers Table from a Northwind database, I think one of the column(s) exceeds the data type size limit, that is ...Answered | 1 Replies | 1883 Views | Created by lagartija75 - Wednesday, October 21, 2015 10:58 PM | Last reply by Hardz Tarrayo - Thursday, October 22, 2015 1:08 AM -
0 Votes
truncate
That is listed as restriction section in MSDN page http://msdn.microsoft.com/en-us/library/ms177570.aspx Restrictions You ...Answered | 1 Replies | 2531 Views | Created by SLNSH - Thursday, July 11, 2013 11:10 AM | Last reply by Satheesh Variath - Thursday, July 11, 2013 11:21 AM -
1 Votes
OLE DB Destination does not include truncation redirect...why
Hi, OLE DB Destination does not include truncation redirect...why?Answered | 9 Replies | 1009 Views | Created by Mr Shaw - Thursday, May 8, 2014 2:57 PM | Last reply by Murali dhar - Tuesday, May 20, 2014 2:17 PM -
1 Votes
Entity Framework + sqlce 4 = string truncation in SELECT
i also have patched sqlserverce.dll and now it truncates strings. it helps, but it's a very bad solution.Answered | 7 Replies | 4918 Views | Created by ru.Tonik - Wednesday, August 22, 2012 9:42 AM | Last reply by ru.Tonik - Thursday, August 30, 2012 10:18 AM -
0 Votes
String or binary data would be truncated error
As why the error only shows up when you add the condition - it may seem strange but in fact it is not.Answered | 6 Replies | 942 Views | Created by Deepak.kumar.Chauhan - Thursday, September 8, 2016 8:08 AM | Last reply by Erland Sommarskog - Thursday, September 8, 2016 10:33 AM - Items 1 to 20 of 2855340 Next ›
No announcements
