[postgis-devel] [PostGIS] #1965: turkish locale breaks postgis

PostGIS trac at osgeo.org
Wed Nov 14 15:56:57 PST 2012

#1965: turkish locale breaks postgis
 Reporter:  plq      |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.2
Component:  postgis  |     Version:  2.0.x        
 Keywords:           |  
Changes (by pramsey):

 * cc: mcayland (added)


 OK, replicated on Centos. On linux, under the tr_TR locale, the value of
 toupper(i) seems to be 'i' instead of 'I'! So 'point' becomes 'POiNT'!
 Also curious, when I try to work around the problem with
 create table some_table(geom geometry(POINT, 4326))
 the modifier "POINT" still arrives at the geometry_type_from_string
 function as "point"! So somewhere in PgSQL the damn thing is already being
 forced to *lower*!

 The behavior of toupper seems like a Linux quirk, unless the upper case
 value of i in the Turkish locale really is 'i' (while all the other latin
 characters *are* being sent to their corresponding uppers?)

Ticket URL: <http://trac.osgeo.org/postgis/ticket/1965#comment:10>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.

More information about the postgis-devel mailing list