[GRASS-dev] [GRASS GIS] #3548: sql where statement encoding issue on windows

[GRASS GIS]

#3548: sql where statement encoding issue on windows
-----------------------------------------------+-------------------------
 Reporter:  martinl                            |      Owner:  grass-dev@…
     Type:  defect                             |     Status:  new
 Priority:  major                              |  Milestone:  7.4.1
Component:  Database                           |    Version:  7.4.0
 Keywords:  select, where, wingrass, encoding  |        CPU:  Unspecified
 Platform:  Unspecified                        |
-----------------------------------------------+-------------------------
 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
 attachment:grass_bug_windows_db_select.png. It seems to be encoding issue,
 tested with Czech Windows 8.1 localization (cp1250). Strangely, records
 with diacritics appear correct in GRASS GUI, see
 attachment:grass_bug_windows_encoding.png

-- 
Ticket URL: <https://trac.osgeo.org/grass/ticket/3548>
GRASS GIS <https://grass.osgeo.org>