Hi Alexis,

Is it in SQLite local database using V4RB plugin?

Let's analyze the contents of your query string
1) Assign it to the separate variable, put a breakpoint the line and stop on it (Step 1.png).
2) View the contents of the query variable and make a screenshot (Step 2.png)
3) View the contents in Binary form and make a screenshot (Step 3.png)

Please attach your screenshots for steps 2 and 3.

No using V4RB plugin
i am using xojo sqliteDatabase open the file create by VS.

but the problems i found if i use copy and paste i have error and if i type the text works so i do'not now is problems is xojo or VS

Ok, the same Byte Order Mark problem. You can check it viewing query in Binary form.
So it appears after copy/paste. Thanks for this detail, I'll add it to my post.

It's more likely a Xojo problem. Solving it in V4RB/VServer would affect the performance, Xojo shouldn't save BOM at all.

ok
but can you report that problems to XOJO company or No.

this is i big problems to use valentina to guest all time for an error

i open a case with XOJO with the problem.

Thank you, this will bring this problem to their attention.
We'll also ask on Xojo forum.

hi
i have this case # 57247 in XOJO Feedback can you post more info

So they gave a good advice:

1: Highlight the text (possibly the entire method)
2: Open the code editor context-menu (normally a right-click with the mouse)
3: Select "Clean invisible ascii characters"

That way, invisible characters are replaced with another character, by default it is '•' (not removed).
And then we have to use find/replace to remove them all.

thanks