Convert or Cast ntext to Nvarchar
Answered
I am receiving an error that states cannot perform a distinct on ntext. In YF, can I convert an ntext datatype to nvarchar? I have tried several different formats and nothing seems to be working. If this conversion is possible, what is the correct format?
CAST(Resolution as nvarchar(4000))
CAST("Resolution" as nvarchar(4000))
CAST("HPD:Help Desk"."Resolution" as nvarchar(4000))
Whatever I do results in an "Unsupported construct in column names" error.
The same question
Hi Shawn,
did you try the Convert function, it worked for me - I created an ntext column in a SQL Server db:
then I was able to convert it to nvarchar in a calc field in a Yellowfin report:
and then finally use a DISTINCT on it:
Please let me know how you get on with this.
regards,
David
Hi Shawn,
did you try the Convert function, it worked for me - I created an ntext column in a SQL Server db:
then I was able to convert it to nvarchar in a calc field in a Yellowfin report:
and then finally use a DISTINCT on it:
Please let me know how you get on with this.
regards,
David
Thanks for the response Big Dave! I tried exactly that. I tried the convert. I tried the cast. Nothing works. Let me also state, I am working with BMC Remedy Smart Reporting. It is my understanding this sits on top of Yellow Fin. Perhaps they have stripped out some functionality. I finally heard back from BMC Support. They are saying I need to create a new DB field with a different data type (other than ntext).
Thanks for the response Big Dave! I tried exactly that. I tried the convert. I tried the cast. Nothing works. Let me also state, I am working with BMC Remedy Smart Reporting. It is my understanding this sits on top of Yellow Fin. Perhaps they have stripped out some functionality. I finally heard back from BMC Support. They are saying I need to create a new DB field with a different data type (other than ntext).
Hi Shawn,
ah yes, BMC Remedy Smart Reporting! That makes sense because I know they have their own bespoke JDBC driver, whereas I was using the Microsoft SQL Server JDBC driver.
Well, if BMC recommend you need to create a new DB field with a different data type then I would definitely follow their advice.
regards,
David
Hi Shawn,
ah yes, BMC Remedy Smart Reporting! That makes sense because I know they have their own bespoke JDBC driver, whereas I was using the Microsoft SQL Server JDBC driver.
Well, if BMC recommend you need to create a new DB field with a different data type then I would definitely follow their advice.
regards,
David
Replies have been locked on this page!