View the original community article here
Last tested: Jul 3, 2019
You can use prefix N notation in the sql parameter of a dimension or other sql_* parameter types however this could lead to issues with filtering on the dimension.
For example, if you have a dimensions with
sql: N'Hello' ;; and then filter on that dimension in an explore for
is equal to 'Hello', Looker will not generate
N'Hello' in the
WHERE clause so you will see no results in some cases, depending on the database settings.
The better thing to do in this case is to configure the SQL server with a Collation that supports the desired string literals, and then never use the N'' prefix. https://docs.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support?view=sql-server-2017