Collections:
CHAR(n) - Truncating/Padding Strings in SQL Server Transact-SQL
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL?
✍: FYIcenter.com
When the length of the input string does not match the storage size of the fixed length string data type CHAR(n). SQL Server will:
The tutorial exercise shows you good examples of truncating and padding fixed length character strings:
-- Length matches the data type size DECLARE @msg CHAR(36); SET @msg = 'Welcome to FYIcenter.com SQL Server!'; PRINT '('+@msg+')'; ---------------------------- (Welcome to FYIcenter.com SQL Server!) -- Length is bigger than the data type size - truncated DECLARE @msg CHAR(24); SET @msg = 'Welcome to FYIcenter.com SQL Server!'; PRINT '('+@msg+')'; ---------------------------- (Welcome to FYIcenter.com) -- Length is smaller than the data type size - padded DECLARE @msg CHAR(46); SET @msg = 'Welcome to FYIcenter.com SQL Server!'; PRINT '('+@msg+')'; ---------------------------- (Welcome to FYIcenter.com SQL Server! )
⇒ Unicode String Literals in SQL Server Transact-SQL
⇐ Casting Strings to Wrong Code Pages in SQL Server Transact-SQL
2017-05-13, 4723🔥, 0💬
Popular Posts:
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...