Hi, I had the same trouble.
Maybe the causes are diferents, but I wnat to share it with us.
I have a string with polish characters.
Then char by char, i review it and I do a replace.
the "enter" or char(13) in hexadecimal is like: H0D H0A (togheter).
In my replacement I use: HOD changed by H20 (space) and H0A changed by NULL (H00).
the final string look fine, and when I test it directly on an SQL Editor, my sentences (insert into) work very well, but when it instruction (insert into) is launched from my ODBC conection, it FAIL.
To correct it mistake, I has changed H0D = H20 and H0A = H20 too. and I donīt have two separators char, justo one. And now I donīt have more this mistake.
I hope that it could help you.