Sorry, I didn't get back to you sooner but I tried both workaround and the first one worked for me

select cast(column_name as varchar(32767)) from table;

The second one didn't work in my case.

Thank you very much for your help.

Hello Don

I'm facing the exact same issue. Did you find a workaround?