Re: C# insert data with special characters to DB2? (Steve Richter)

I should know better to post a question at the end of the day when I'm frustrated. This is screen-scraped data from a vendor api call. I don't actually need the special characters. I only have about 14 out of every 1000 records that have the one problematic column.

What I would like to do is keep the default ccsid on the db2 table and column - this would avoid any programming issues.
I noticed when I did a console.writeline that the data had questions marks where the special characters were. This seems like it would be a great solution I just don't know how to make that happen in the code.

Per Steve's request here's a small piece of the code:

cmd.CommandText = "update INproductstb set id=@id, " +
"title=@title, " +
" where LampsSku = @Sku";
cmd.Parameters.AddWithValue("@id", apiData.response.products[0].id);
string title37 = apiData.response.products[0].title.ToString();
Console.WriteLine(title37);
cmd.Parameters.AddWithValue("@title", apiData.response.products[0].title);

The title field is the problem field - it seems like I should be able to do something with the string - but I'm not sure what.

Apologies in advance - I've never posted code here - I thought there was a FAQ or some guidelines but I wasn't able to find them.

Thanks.
Vicki