Re: Can’t pass plus sign (+) in a char field to a stored proc?

Home Forum General Can’t pass plus sign (+) in a char field to a stored proc? Re: Can’t pass plus sign (+) in a char field to a stored proc?

#5858

pmeidinger
Participant

Not being able to send non-alpha characters to a stored procedure is a huge concern for me, so I went through our other forms to see which ones send data to the database via a stored proc. I tested one and was able to send this string

+_)(*&^%$#@!~`|]}[{‘”;?.>,<

to the database successfully. So it seems you *can* send special characters. However, this data came from a Text Input in the form, and my initial problem was that the plus sign wasn’t being sent from a Drop-Down. Is it just the Drop-Down that can’t send the plus sign? I know it can send the minus sign to a stored proc. It would be helpful to get a definitive answer on this issue.