Problems with MSSQL Prepared Statement

Databases
21

Did you try to DefineEncoding for the textfields? The data is coming from a client so the server could be unaware of the string encoding. Maybe check in the debugger if the encoding is set to an expected value?

It looks like some kind of parsing is going wrong, so instead of splitting a (json) string into parts it’s just parsing it on still somewhere… I think this is web-related more than DB related.

22

I was able to recreate the issue with desktop.

I tried defining when you first suggested it. I also tried changing the collation on the DB to UTF-8. Still no luck.

EDIT: The desktop version wasn’t nearly as drastic. Usually a ) or an random letter was inserted, not the usual stuff.

23

Ok that clears it up, then it’s more likely to be a xojo msssql plugin bug.