Search code examples
sqlsql-server-2008isnull

ISNULL expression shows ??? -s in the result

I have a query which is similar to this:

SELECT 
    Field.Table1, 
    Field.Table2, 
    ISNULL(Field.Table3, 'My text here') 
FROM Table.

'My text here' is in Georgian Unicode (which literally looks like this 'ვერცხლი'). As a result of my query I get ??????? -s instead of the text I've put in ISNULL. The same happens when i try to input Russian Cyrillic as 'My text here' .

Field.Table3 is nvarchar(150), not null. It can get NULL in my query because of the Outer Join I use there (which I did not mention above).

Can anyone help me with it?

Solution

  • Use N before string definition

    SELECT 
    Field.Table1, 
    Field.Table2, 
    ISNULL(Field.Table3, N'My text here') 
FROM Table.