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

[PostGIS]

#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)


Comment:

 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.