New answers tagged

9

The UCS-2 encoding is always 2 bytes per character and has a range of 0 - 65535 (0x0000 - 0xFFFF). UTF-16 (regardless of Big Endian or Little Endian) has a range of 0 - 1114111 (0x0000 - 0x10FFFF). The 0 - 65535 / 0x0000 - 0xFFFF range of UTF-16 is 2 bytes per character while the range above 65536 / 0xFFFF is 4 bytes per character. Windows and SQL Server ...


1

The COLLATE clause of CREATE DATABASE can be used to specify a collation different from the Default Server collation. Also, if the databases were backed up from another server, they would be restored with the collation they had on the source server. If they are created using CREATE DATABASE and a collation is not specified via the COLLATE keyword, then ...



Top 50 recent answers are included