Find, AppendEquals and apostrophe

Some Scottish and Irish surnames use an apostrophe after an M or O, for example O'Brien. It seems like SqlUtil.Encode function replacing that apostrophe with '' first and then it is replaced again when in Command. So finaly the find parameter looks like @Param0 = N'O''''Brien' instead of @Param0 = N'O''Brien' what results wrong find results.

Hello,

I’ve ran into this before, what I do if I know that I could have text that has the possibility of containing a character like ‘. I escape it during any CRUD operations by doing a string replace with a specific character like ^ beforehand. I’ve found that you could try encoding it but most of the time it will just create more headaches.

Thanks

Blake Niemyjski

Hi Blake,

NetTiers it is doing that anyway - I was just saing that when using ParameterBuilder's Append or AppendEquals it uses SqlUtil.Encode that is actually duplicating what is done next.