No announcements
Found 1006462 threads
-
0 VotesTruncating VARCHAR(max)
First, no matter how long a varchar(max) or nvarchar(max) is, PRINT only shows the first 8000 characters of a varchar(max) ...Answered | 5 Replies | 7314 Views | Created by mielkeac - Friday, May 24, 2013 3:07 PM | Last reply by Tom Cooper - Friday, May 24, 2013 4:29 PM
-
0 Votes
varchar(max) as an out parameter to stored procedure is getting truncated to varchar
Also you can use a temp table or return a table variable to send non-binary large-value data back to java program, for more details, please review this similarAnswered | 7 Replies | 2313 Views | Created by beingmansoor - Wednesday, February 18, 2015 5:21 AM | Last reply by Lydia Zhang - Thursday, February 19, 2015 5:10 AM -
0 Votes
Varchar(max) truncated to char 24 or 32 with native client 11 odbc driver
You changed varchar(max) columns to other data types or ?Unanswered | 8 Replies | 1455 Views | Created by JaPasst - Wednesday, July 25, 2018 9:56 AM | Last reply by JaPasst - Thursday, August 2, 2018 3:06 PM -
0 Votes
insert into varchar(max) truncation issue
The REPLICATE documentation says "If string_expression is not of type varchar(max) or nvarchar(max), REPLICATE truncates the return value at 8,000 ...Answered | 2 Replies | 3092 Views | Created by ggolub - Saturday, January 27, 2018 5:56 PM | Last reply by ggolub - Saturday, January 27, 2018 8:53 PM -
0 Votes
Change Default Driver (sqlcmd using Native Client 11)
What issue do you have with SQL Server Native Client 11?Answered | 1 Replies | 6551 Views | Created by IntelGuy67 - Wednesday, September 24, 2014 3:18 AM | Last reply by Erland Sommarskog - Wednesday, September 24, 2014 9:46 PM -
0 Votes
sql native client 11
SQL Server Native Client 11 is a DLL with both an ODBC driver and an OLE DB provider.Answered | 1 Replies | 2094 Views | Created by Risingflight - Tuesday, August 30, 2016 8:00 PM | Last reply by Erland Sommarskog - Tuesday, August 30, 2016 9:50 PM -
0 Votes
varchar(max) field throwing truncated field error
varchar(max) can hold much more, up to 2GB of data.Answered | 2 Replies | 4986 Views | Created by TimPoll - Tuesday, May 15, 2012 5:08 PM | Last reply by Naomi N - Tuesday, May 15, 2012 7:41 PM -
0 Votes
Access / ODBC / SQL Server Error - String Data Right Truncation Error with NVARCHAR(MAX)
While ODBC Driver for SQL Server 11 is well referenced and there is an easy to find download for it, The Native Client is confusingly ...Answered | 3 Replies | 3236 Views | Created by AnandaSim - Friday, November 6, 2015 1:21 AM | Last reply by mklaey - Monday, November 9, 2015 11:44 AM -
0 Votes
SQL Server Native Linux ODBC Client Support of unixODBC 2.3.1
Regarding to the Microsoft SQL team Blog mentioned some instructions and explains how to make the Native Client ODBC driver ...Answered | 1 Replies | 6078 Views | Created by David McLennan - Friday, March 16, 2012 11:32 PM | Last reply by amber zhang - Monday, March 19, 2012 3:12 AM -
0 Votes
Data truncated to characters with Excel 2003 ODBC driver
I want to create a new excel file(2003) and write many things to it through ODBC.Answered | 6 Replies | 7140 Views | Created by contactme - Wednesday, December 15, 2010 6:29 PM | Last reply by 0905 - Wednesday, April 27, 2011 1:15 AM -
0 Votes
ODBC connection failed (SQL Server Native Client)
I created MAPDB database manually, then successfully connected betwenn ODBC and Native Client.Answered | 3 Replies | 6065 Views | Created by kkikkiKim - Monday, October 20, 2014 9:15 AM | Last reply by kkikkiKim - Monday, October 20, 2014 10:42 AM -
1 Votes
Access Memo -- SQL text (or varchar(max)) field
Hi, I see your problem and i am able to reproduce the same error when i try to update linked table that has varchar(max).Answered | 6 Replies | 17650 Views | Created by Jim56 - Monday, December 5, 2011 10:40 PM | Last reply by Vinay Valeti - Monday, December 5, 2011 11:43 PM -
1 Votes
Classis ASP Varchar(max)
Am using ADODB connection to read a store procedure and one of the field in the store procedure is defined as varchar(max).Answered | 2 Replies | 2463 Views | Created by Benjin Thomas - Tuesday, October 1, 2013 12:17 PM | Last reply by Benjin Thomas - Wednesday, October 2, 2013 5:36 AM -
0 Votes
ODBC Drivers
Hello, You have installed the "SQL Server Native Client" and this includes all data provider, OleDB and also ODBC, see The SQL Server ...Answered | 3 Replies | 1424 Views | Created by VijayKSQL - Tuesday, July 21, 2015 4:00 PM | Last reply by Olaf Helper - Tuesday, July 21, 2015 6:04 PM -
0 Votes
MSAccess linked to SQL Driver for VARCHAR(MAX) > 8000
When I exceed 8000 characters I get the error "text too long to be edited" I've tried the SQL Native Client and the ODBC ...Answered | 1 Replies | 2848 Views | Created by Shane Morris - Friday, August 23, 2013 8:34 PM | Last reply by Olaf Helper - Sunday, August 25, 2013 6:34 AM -
1 Votes
varchar (8000) and varchar(MAX)
i understand that the function EXECUTE reduce to 4000 but why when i put varchar(MAX) , i dont have this limit .Answered | 7 Replies | 1094 Views | Created by jamestounde - Friday, March 9, 2018 11:15 AM | Last reply by Liju Lalithangathan - Friday, March 9, 2018 12:38 PM -
0 Votes
SQL Linked Server to ODBC, OpenQuery Data Gets truncated
Hi, Please find attached ODBC Edition information. i am trying to retrieve around 50000 Rows.Answered | 2 Replies | 2294 Views | Created by kalpesh23 - Wednesday, August 10, 2016 12:16 PM | Last reply by kalpesh23 - Friday, August 26, 2016 7:08 AM -
2 Votes
Ruby ODBC driver siliently truncate long string
Unfortunately ruby-odbc is an open source driver maintained by the community - https://github.com/larskanis/ruby-odbc.Answered | 1 Replies | 916 Views | Created by Roy0123 - Thursday, June 18, 2015 4:39 AM | Last reply by Meet Bhagdev - Thursday, June 18, 2015 5:41 AM -
1 Votes
VARBINARY -vs- VARBINARY(MAX) truncate issue
Here's some info (http://blogs.msdn.com/b/yukondoit/archive/2005/11/24/496521.aspx) you and others may find useful that did solve my problem. The ...Answered | 15 Replies | 12652 Views | Created by SAL - Thursday, April 5, 2012 7:14 PM | Last reply by Erland Sommarskog - Monday, April 9, 2012 7:37 PM -
0 Votes
Difference between varchar and varchar(max)?
VARCHAR is a data type similar to CHAR data type except it has the ability to store the exact length of the given data instead of leaving blank spaces for the given length limit .Answered | 7 Replies | 5155 Views | Created by iamanujit - Wednesday, December 10, 2014 11:16 AM | Last reply by RK-SQLDBA - Saturday, December 13, 2014 3:08 PM - Items 1 to 20 of 1006462 Next ›
No announcements
