Hi All,
I am trying to update data from one table to other table using execute store procedure smart service but i am getting below error while executing smart service.
(conn=8566693) Incorrect string value: '\xAC\xED\x00\x05ur...' for column.
can any one suggest what it is referring for.
Thanks in Advance
Discussion posts and replies are publicly visible
Sounds like you're trying to insert some text with advanced features (unicode / emojis / etc) into a text column that can't handle it.
Hi Mike,
I am not writing any emojis or Unicode just text values writing it from one table to other table using sp.
and I am passing parameters to sp through pv in process model
(if i execute sp manually in data base and pass the parameter it is working fine & facing issue while using execute sp smart service).
Sharing some code might help us to support you.
The value you shared ('\xAC\xED\x00\x05ur', etc) suggests it's trying to process some disallowed special characters - I can't say much more without specifics.