View Issue Details

IDProjectCategoryView StatusLast Update
0008580VALENTINA SERVERSQLite Serverpublic2019-08-31 14:23
ReporterSergey PashkovAssigned To 
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionnot fixable 
Product Version9.3.x 
Target Version9.3.xFixed in Version 
Summary0008580: UTF BOM characters are not processed correctly by SQLite
DescriptionThe situation happened for two users: first used V4RB+Valentina SQLite Server the second used REST+Valentina SQLite Server.

Somehow UTF-8 BOM (EF BB BF) appeared in the query text in the Xojo source file.
It was passed to V4RB/REST API, from the client to the server, even transformed to UTF-16 BOM and back to UTF-8 BOM if the conversion happens.

But SQLite engine treats BOM like an ordinary character - as part of a command or the identifier.
It returns an error. But BOM is invisible, so the message doesn't give any hint to the ordinary user.

When the error is written to the log, it is possible to view it in HEX format and find BOM which breaks the query.

We have to strip BOMs on some stage.

Additional Informationhttps://valentina-db.com/en/discussions/5933-problem-with-xojo-report-adk-in-local-with-sqlite-db-in-server#reply-5940
TagsNo tags attached.

Activities

Sergey Pashkov

Sergey Pashkov

2019-07-22 15:17

developer   ~0010897

This is a sample project containing EF BB BF before the query text

POS ERCF_Printing online_v0.1.xojo_binary_project (31,776 bytes)
Sergey Pashkov

Sergey Pashkov

2019-07-22 15:18

developer  

Screenshot 2019-07-22 18.16.22.png (207,200 bytes)
Sergey Pashkov

Sergey Pashkov

2019-08-31 14:23

developer   ~0010965

The user has opened a Xojo case, can be viewer by Xojo Feedback app:
57247 - Copy and Paste code in XOJO (BOM)

The proposed solution is:
After pasting the text, try:
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"

Issue History

Date Modified Username Field Change
2019-07-19 07:05 Sergey Pashkov New Issue
2019-07-19 21:10 Sergey Pashkov Description Updated View Revisions
2019-07-22 15:13 Sergey Pashkov Description Updated View Revisions
2019-07-22 15:13 Sergey Pashkov Additional Information Updated View Revisions
2019-07-22 15:17 Sergey Pashkov File Added: POS ERCF_Printing online_v0.1.xojo_binary_project
2019-07-22 15:17 Sergey Pashkov Note Added: 0010897
2019-07-22 15:18 Sergey Pashkov File Added: Screenshot 2019-07-22 18.16.22.png
2019-08-31 14:23 Sergey Pashkov Note Added: 0010965
2019-08-31 14:23 Sergey Pashkov Status new => closed
2019-08-31 14:23 Sergey Pashkov Resolution open => not fixable