Re: C# insert data with special characters to DB2?

You could also url encode or html escape the string. But then of course you would need to reverse it when reading the data.

On Thu, Apr 2, 2015 at 7:46 PM, Vicki Wilson <VWilson@xxxxxxxxxxxxx> wrote:

Hi all,

The saga with moving the database from SQL server to DB2 continues.

My C# code is upchucking on an update statement. One column has special
characters and I get a conversion error on the update. I tried to change
the column on DB2 to CCSID 65535 but I still get a conversion error -
different one this time.

Any thoughts? Can I do something fun with the SQL statement? Connection
String? This is a parameterized query using AddWithValue.
Regex or scanning the column every time seems like the least desirable
solution.

Thanks.
Vicki Wilson