bibi92
asked on
Cannot Convert between Unicode and Non Unicode String Data Type
Hello,
In T-SQL script, if I change the following deliveryInstruction by DeliveryInstruction = ''
DeliveryInstruction = replace(replace(replace(re place(subs tring((sel ect ', ' + ST_NoteText from Test.DBO.StmNote where ST_Description = 'Import Delivery instructions' and ST_ParentID = JobShipment.JS_PK FOR XML PATH('')), 3, 1000),'
',''),ascii(1 3),''),asc ii(10),'') ,'&',' &'),
The following error is generated :
Cannot Convert between Unicode and Non Unicode String Data Type
Why?
Thanks
Regards
In T-SQL script, if I change the following deliveryInstruction by DeliveryInstruction = ''
DeliveryInstruction = replace(replace(replace(re
The following error is generated :
Cannot Convert between Unicode and Non Unicode String Data Type
Why?
Thanks
Regards
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
???
ASKER
Hello,
I try :
I have replaced DeliveryInstruction = '' by DeliveryInstruction = CAST(N'' AS NVARCHAR(MAX)) ,
Thanks
I try :
I have replaced DeliveryInstruction = '' by DeliveryInstruction = CAST(N'' AS NVARCHAR(MAX)) ,
Thanks
We are all anxiously waiting for you to tell us what is the question? I do realize that English may not be your first language, so just a simple query showing the wrong output and the expected output would suffice.
ASKER
Ok, I will do it for the next question. I have replaced
DeliveryInstruction = ''
by
DeliveryInstruction = CAST(N'' AS NVARCHAR(MAX))
and the error Cannot Convert between Unicode and Non Unicode String Data Type is resolved.
DeliveryInstruction = ''
by
DeliveryInstruction = CAST(N'' AS NVARCHAR(MAX))
and the error Cannot Convert between Unicode and Non Unicode String Data Type is resolved.
ASKER
This help to find a solution
ASKER
I search how to replace NTEXT column by NULL value.
Thanks
Regards