Sunday 21 October 2018

CodePage in Execute SQL Task in SSIS

When we are working on Execute SQL Task we are seeing CodePage 1252.

   


A code page, also known as a character set, is a set of 256 uppercase and lowercase letters, numbers, and symbols. The printable characters of the first 128 values are the same for all character set choices. The last 128 characters, sometimes referred to as extended characters, differ from set to set. The code page for SQL Server determines both the types of characters that SQL Server recognizes in your database and the results that SQL Server returns for queries that involve character comparisons. Here we specify the code page to use when translating Unicode values in variables.

No comments:

Post a Comment

If you have any doubt, please let me know.

Popular Posts