Can NVARCHAR be null?

[chr_br]

Hello all,

I stumbled today that a Calculated Column in a Calculation View wants to convert a null value return to integer.

Can someone explain this to me?

Example: If I define a field as NVARCHAR and determine the field contents via if statement, in some cases a null value should be returned and not an empty string or similar.

However, the activation fails because there is a data type conversion problem. HANA wants to convert NULL to an integer and the Calculated Column is defined as NVARCHAR.

How to understand this? Null represents the absence of a value, so how can it be an integer?

[KonradZaleski]

Can you provide your column definition plus screen from the calculated column?

[chr_br · Accepted solution]

I solved the problem by converting NULL to string.

So the code in calculated column looks like:

if("..." = '01', "...", string(Null))