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, 4751🔥, 0💬
Popular Posts:
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...