[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
Resolution:               |   Keywords:  select, where, wingrass, encoding
       CPU:  Unspecified  |   Platform:  Unspecified
--------------------------+-----------------------------------------------
Description changed by martinl:

Old description:

> 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

New description:

 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

 [[Image(grass_bug_windows_db_select.png, 500px)]].

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

 [[Image(grass_bug_windows_encoding.png, 500px)]]

--

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