devxlogo

Use Unicode Strings in SQL Intelligently to Save on Storage

Use Unicode Strings in SQL Intelligently to Save on Storage

Unicode characters use more storage space than characters in a regular SQLServer character set use. A regular SQL Server character set is a single-byte set that supports up to 256 characters. Unicode is a double-byte set that supports as many as 65,536 distinct values. Each stored character in the extra range of supported characters consumes space.

devx-admin

Share the Post: