sql where statement encoding issue on windows

[martinl]

SQL WHERE statements with diacritics on Windows return no records. It seems to be a bug. Same command performed in GRASS GUI (no record, wrong) and SQLiteBrowser (one record, correct). See

.

It seems to be encoding issue, tested with Czech Windows 8.1 localization (cp1250). Strangely, records with diacritics appear correct in GRASS GUI. See

[martinl]

Tested also from command line:

# no diacritics, works
C:\>db.select sql="select count(*) from obce where nazev='Kladno';
count(*)
2

# diacritics involved, fails
C:\>db.select sql="select count(*) from obce where nazev='Aš';
count(*)
0

Debug:

D2/5: path to db is C:\Users\landa\Documents\grassdata\ArcCR500\PERMANENT\sqlite

D3/5: Escaped SQL: select count(*) from obce where nazev='Aš';
D3/5: describe_table()
D4/5: this is not a table column
D3/5: sqltype = 3
D3/5: litetype = 1
D3/5: nkcols = 1
D4/5: this is not a table column
D3/5: sqltype = 3
D3/5: litetype = 1
D3/5: col: count(*), nkcols 0, litetype : 1, sqltype 3
count(*)
D3/5: fetch row = -1
D3/5: col 0, litetype 1, sqltype 3: val = '0'
D3/5: Row fetched
0
D3/5: fetch row = 0
D3/5: db_close_database()

[martinl]

Tested also on Linux (same data, same import command). Works, seems to be really encoding issue on Windows.

[neteler]

Ticket retargeted after milestone closed

[martinl]

Bump milestone to 7.4.4

[neteler]

Ticket retargeted after milestone closed