Tag Archives: char

CHAR Datatype and ConCat in Oracle and SQL Server.

Char is a Fixed length data type, provided by database to stored Character Data. It will allocate fix bytes as per length specified for CHAR datatype and will pad with Space for remaining chunks. With Variable declare as CHAR(20), Byte … Continue reading

Rate this:

Posted in SQL Server Learning | Tagged , , , | Leave a comment

FIXED length character storage and NULL in SQL Server.

Most of us must be aware of CHAR datatype and its fixed length storage pattern. If we declare CHAR(32) and store only 4 bytes character ‘ABCD’, It will pads up remaining bytes (28 bytes). Ultimately, whole bytes is consume for … Continue reading

Rate this:

Posted in SQL Server Learning | Tagged , , , , | Leave a comment