Have a table (SQL Server 2008) that the user wants to record a fixed 8 character string in. At first glance, a CHAR seems the obvious selection since this value (an 8 character ID, two alpha ...

In contrast, PostgreSQL's VARCHAR is inherently based on UTF-8 Unicode, making it more flexible in terms of character set support. Here are the main differences in VARCHAR between SQL Server and ...