I was trying to create the Patient Portal app. While creating the data model, I selected the data type of the Image attribute as binary. I have not input any data in the image attribute. Then I created a screen where I used this attribute inside the form widget. Then when I tried to publish the screen, it showed me that the expected data type for the image should be "Text" instead of "Binary". Afterward, I changed the data type of the Image attribute to Text in the "Data" tab. Now, it is showing me an error and showing the following statement,"Database varbinary columns cannot be changed".
Now my question is how can I eliminate the error and convert the data type of Image to Text?
The error you're encountering occurs because a database column created as binary cannot be directly changed to text.
Hello, @Md Zulfikar Hasan
this post will help you, Please Check
Best Regards
Priya Jhode
You mentioned that your form includes an image with the expected datatype set to Text. It appears that the Type attribute of the image is set as External URL, which is why you’re encountering the error: “‘Text’ data type required instead of ‘Binary Data’.” To resolve this, change the Type to Binary Data, and the error should disappear.