No announcements
Found 1116742 threads
-
0 VotesDifference Between Char and Varchar
Hi Suderson, Below are the differences between CHAR and VARCHAR data type: 1. The char is a fixed-length character data ...Answered | 6 Replies | 7434 Views | Created by Suderson Parthasarathy - Tuesday, May 4, 2010 2:26 PM | Last reply by KiranKumar.Y - Friday, May 7, 2010 1:32 PM
-
0 Votes
Database - Char vs Varchar(1), Should I only use Varchar?
insignificant in SQL Server, this distinction is kind of hard to make. Also, char(1) takes up one byte. varchar(1) takes up two or three bytes. ...Proposed | 6 Replies | 1688 Views | Created by Ihandler MSDN - Friday, May 22, 2020 3:37 AM | Last reply by MIAOYUXI - Friday, May 29, 2020 12:55 AM -
1 Votes
Error with substring seperating data by char(10)+char(13) line breaks
:' Then SUBSTRING(CONVERT(VARCHAR(MAX), soship.fmstreet),7,CHARINDEX(CHAR(13)+CHAR(10),CONVERT(VARCHAR(MAX), soship.fmstreet + ...Answered | 13 Replies | 590 Views | Created by David9501 - Tuesday, September 11, 2018 7:09 PM | Last reply by .theDBguy - Wednesday, September 12, 2018 2:44 PM -
0 Votes
Script Table in SSMS 2008 Converts Computed Column to Regular Column
CREATE TABLE [dbo].[RecipEligToVendor]( [RawData] [varchar](max) NULL, [SAK_RECIP] AS ...Answered | 3 Replies | 6115 Views | Created by Stamey - Friday, May 14, 2010 5:46 PM | Last reply by Stamey - Monday, May 17, 2010 3:04 PM -
1 Votes
Char Varchar
executed, a char column that is defined as NULL is handled as varchar.Answered | 1 Replies | 5341 Views | Created by AndyMay - Wednesday, November 3, 2010 10:19 PM | Last reply by Ali Hamdar - Wednesday, November 3, 2010 10:27 PM -
0 Votes
sp_send_dbmail does not work with attachment
;'.csv' DECLARE @query_result_separator CHAR(1) = char(9); --comma SET @query = 'set nocount on;select * fromProposed | 3 Replies | 2759 Views | Created by kvd123 - Tuesday, January 21, 2014 8:49 PM | Last reply by Kalman Toth - Wednesday, January 22, 2014 9:34 AM -
0 Votes
Varchar vs char
being used. One character is the same size 'in storage' whether you 'declare' it char(1) or ...Unanswered | 4 Replies | 7319 Views | Created by Badajoz95 - Monday, November 10, 2008 10:03 PM | Last reply by gvee - Tuesday, November 11, 2008 12:55 PM -
1 Votes
Varchar/char column problems
= 175 then 'char' else 'varchar' end + '(' + case when max_length = -1 then 'MAX' else ...Answered | 3 Replies | 4001 Views | Created by PetedeLux - Wednesday, February 11, 2009 10:22 PM | Last reply by Kris_DB_Architect - Friday, February 13, 2009 7:48 AM -
1 Votes
what is the difference between updating null value Vs empty string to varchar/char field?
There is a pretty significant difference between CHAR and VARCHAR however. Char implies a set length of data. Lets say for example you have a Name field ...Answered | 6 Replies | 11206 Views | Created by RubaKM - Wednesday, August 29, 2007 1:38 PM | Last reply by Sean Fowler - Sunday, September 9, 2007 8:44 PM -
1 Votes
The weird behavior of CAST(-1 as varchar(1))
Hi. Can anyone please explain to me why CAST(-1 as VARCHAR(1)) returns an asterisk '*' and CAST(-1 as NVARCHAR(1)) returns an arithmetic overflow ...Proposed | 3 Replies | 426 Views | Created by Darlove - Sunday, January 29, 2017 7:28 PM | Last reply by --CELKO-- - Sunday, January 29, 2017 10:29 PM -
0 Votes
res://ieframe.dll/preview.dlg line 2068 char 1
res://ieframe.dll/preview.dlg line 2068 char 1 outlook print script error Line 2068 -
0 Votes
char(1) and char(2) take same space?
having to touch all the individual records. This is only possible if we can guarantee that the records are at least 9 bytes long. To really see the difference between ...Answered | 12 Replies | 7605 Views | Created by Liweiyin - Tuesday, August 21, 2007 8:28 AM | Last reply by mvdh2 - Wednesday, August 22, 2007 4:13 AM -
0 Votes
MigrateDatasourceDataFromDPM.ps1 - Invalid Input Parameter Specified At Line:1 Char:1
get: C:\Program Files\Microsoft System Center 2012\DPM\DPM\bin\MigrateDatasourceDataFromDPM.ps1 : Invalid input ...Answered | 6 Replies | 2452 Views | Created by adamf83 - Wednesday, May 28, 2014 8:29 AM | Last reply by adamf83 - Wednesday, May 28, 2014 4:24 PM -
2 Votes
char and varchar
char and varchar permits characters from the code page of the collation you use. Thus, the exact set varies, but about all code pages includes the ASCII set for codes points 32 to ...Answered | 2 Replies | 372 Views | Created by VansFannel - Thursday, April 12, 2018 6:48 AM | Last reply by Erland Sommarskog - Thursday, April 12, 2018 7:25 AM -
8 Votes
Choosing between char(n) and varchar(n)
One thing to consider is that there actually IS a difference if you use a LIKE comparison instead of equals... VARCHAR(1) = '' is NOT LIKE ' ' while ...Answered | 19 Replies | 8825 Views | Created by Kamran Shahid - Wednesday, February 17, 2010 1:28 PM | Last reply by Erland Sommarskog - Thursday, December 5, 2019 10:49 PM -
0 Votes
Problem Altering a Column from char(1) to char(3)
( c1 CHAR(1Answered | 4 Replies | 4551 Views | Created by ravi0435 - Tuesday, September 9, 2008 1:56 PM | Last reply by Hunchback - Tuesday, September 9, 2008 2:13 PM -
1 Votes
varchar(50) to char(4)
From a storage perspective, a variable length data type uses two bytes extra. So say you have char(4). You would (always) use 4 bytes for that column. But if you have varchar(4), and ...Answered | 9 Replies | 3352 Views | Created by arkiboys - Tuesday, November 15, 2011 11:33 AM | Last reply by arkiboys - Tuesday, November 15, 2011 3:55 PM -
1 Votes
Difference between %1 and %1% in batch scripting
Hi, Please explain the difference between %1 and %1% in batch scripting(batch commands) ...Answered | 1 Replies | 3566 Views | Created by Agrawal_Amit_31 - Tuesday, September 6, 2011 4:23 AM | Last reply by Frederik Long - Tuesday, September 6, 2011 5:48 AM -
0 Votes
-
0 Votes
Converting Date to 1 Char String?
SELECT CASE WHEN CloseDate IS NULL THEN 0 ELSE 1 END FROM MyTable --BradAnswered | 2 Replies | 3918 Views | Created by Seidel1 - Wednesday, May 6, 2009 2:56 AM | Last reply by Seidel1 - Wednesday, May 6, 2009 3:05 AM - Items 1 to 20 of 1116742 Next ›
No announcements
