Cannot convert from Unicode 120183 to SQLWCHAR. Value is too large.

​@woodzza 

There are a couple of approaches you can use to get your text into ASCII. The easiest is to use the text formatter to convert to ASCII which will replace all non-ASCII characters. Configuration would be as below.

 

The other would be to use a code block, especially if I need to manipulate the data. Python is my preferred language, so I would do something like below.  

 

import re

user_response = input_data['user_response']

# Strip non-ASCII characters using regex
cleaned_response = re.sub(r'[^\x00-\x7F]+', '', user_response)


return {'Cleaned Text': cleaned_response}

Hope this helps.

thanks ​@Badger , this does help give a bit of direction - almost. What I cant see is how to apply this to multiple fields; it seems to allow me to select multiple inputs but then they get combined into a single output as opposed to just having those values updates before being passed to the next step (SQL SERVER).

Thanks so much for marking Badger’s reply as the best answer here ​@woodzza! Really pleased they were able to help get things sorted—and thanks for helping out here, ​@Badger! 🤗 

If there’s anything else you need please do reach back out to the Community again. In the meantime, happy Zapping! ⚡