Corruption of national characters in attribute columns when inserting/editing object in PostGIS

[qgib]

Author Name: Ivan Mincik (Ivan Mincik)
Original Redmine Issue: 2707

Redmine category:digitising
Assignee: nobody -

---

There is corruption of attribute data containing national characters when creating or editing new objects in [[PostGIS]]. The problem every time occurs after some objects are successfully inserted. I can not figure out exact operation causing this issue.

Here is example how can I reproduce problem:

1. I have following spatial table:
   CREATE TABLE gis.rrr
   (
   gid serial NOT NULL,
   test character varying(80),
   the_geom geometry,
   CONSTRAINT rrr_pkey PRIMARY KEY (gid),
   CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2),
   CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTIPOLYGON'::text OR the_geom IS NULL),
   CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = (-1))
   )

2. Table is empty before this test. 'ľšč' are slovak national characters. I will try to do following operations:

• start editing; create one object and insert 'ľšč' in to column 'test'; save
• start editing; create one object and insert 'ľšč' in to column 'test'; save
• start editing; create one object and insert 'ľšč' in to column 'test'; save
• start editing; create one object and insert 'ľšč' in to column 'test'; save
• start editing; create some more objects and insert 'ľšč' in to column 'test'; save
• start editing; create some more objects and insert 'ľšč' in to column 'test'; save
• identify attributes of some features
• start editing; create some more objects and insert 'ľšč' in to column 'test'; save
• identify attributes of some features
  ....
  somewhere here I will see in the log and also in attribute table that I have something like 'ľšÄ�ťžý' instead of 'ľšč' in column 'text'.

I see this problem for longer time with multiple versions. 1.3 - trunk, tested on multiple Debian Lenny systems.

Current test was made using this software:
QGIS: 13321M
OS: Debian Lenny
[[PostGIS]]: POSTGIS="1.3.3" GEOS="3.0.0-CAPI-1.4.1" PROJ="Rel. 4.6.0, 21 Dec 2007" USE_STATS
database encoding: UTF-8
locales: tested with en_US, sk_SK

[[PostGIS]] log is attached.

Ivan

---

• postgresql-8.3-main.log.gz (Ivan Mincik)

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

fixed in 64d2fc8 (SVN r13471).

---

• resolution was changed from to fixed
• status_id was changed from Open to Closed