This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 57.99999999999999%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
I'm having a problem in SQL server when using emojis in column aliases:
with [cte] AS (
SELECT
NULL AS [🍕]
,NULL AS [🍕🤢]
)
SELECT [🍕] FROM [cte]
Msg 8156, Level 16, State 1, Line 1
The column '🍕🤢' was specified multiple times for 'cte'.
Completion time: 2023-03-13T08:44:20.3825178-04:00
Certain emojis work as expected. This query executes successfully:
with [cte] AS (
SELECT
NULL AS [🍕]
,NULL AS [🍕❤]
)
SELECT [🍕], [🍕❤] FROM [cte]
Tested on SQL Server up to version 2022: 16.0.1000.6
And what could that be good for?
Anyway, see Rules for Regular Identifiers, emoji's are not allowed in object/column names.
Can you point me to the documentation about allowed characters in column alias names? The link you provided only states that characters outside those classes must be delimited.
Changing DB collation from SQL_Latin1_General_CP1_CI_AS to Latin1_General_100_CI_AS_SC resolved this issue.
Yes, I was just about to ask. Emojis are not part of the Unicode Baseplane, but you need a collation with support for supplementary characters, that is, characters with a code point > 65536, The SC collations have support for this. Those without SC has not.