[postgis-devel] [PostGIS] #1465: loader/Latin1 regression failure (NetBSD, postgresql 8.4.10)

[PostGIS]

#1465: loader/Latin1 regression failure (NetBSD, postgresql 8.4.10)
---------------------------+------------------------------------------------
 Reporter:  gdt            |       Owner:  mcayland     
     Type:  defect         |      Status:  new          
 Priority:  medium         |   Milestone:  PostGIS 2.0.0
Component:  loader/dumper  |     Version:  trunk        
 Keywords:                 |  
---------------------------+------------------------------------------------

Comment(by gdt):

 To clarify, there are two separate bugs in the regression test:

  * selecting the string doesn't set the encoding, so e.g. if the native
 encoding is ISO8859-1, the ISO8859-1-encoded version of that address
 doesn't mach the UTF-8 version.  This is easy to fix as above.

  * If the database is SQL_ASCII, then 35 bytes that are the UTF-8 version
 of a 32-character address doesn't fit in a varchar(32).   The fix is
 either to use a shorter string, or a longer varchar, or to explicitly
 create the regression database with a particular encoding.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/1465#comment:5>
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.