Hi
We have a solution containing 2.000+ items, where the setting of an initial itemtype field unfortunately has been set to Envode Values - see this https://www.screencast.com/t/DDSaUA4WdMQd
This has resulted in a lot of values being stored in an unwanted manner in the database.
Eg. the value "Føroya Skipaskráseting" has been stored like this "F%c3%b8roya+Skipaskr%c3%a1seting"
Would we have to to a SQL update in order to correct this, or is there another way of correcting existing data to be stored "unencoded"?
If not, what would at typical SQL Statment looklike, for updating a specifik value of a certain itemtype field in the database?
Lets say if the itemtype is named "Ship" and the field is named "Certificate".
And in this specific case - the field is a select dropdown field. Does that play any role, or is it regadless of the specifik type of Item field?
/Hans
