ports/136856: databases/libdbi-drivers: PostgreSQL >= 8.3 naming changes of UNICODE -> UTF8 encoding

[O. Hartmann]

>Number:         136856
>Category:       ports
>Synopsis:       databases/libdbi-drivers: PostgreSQL >= 8.3 naming changes of UNICODE -> UTF8 encoding
>Confidential:   no
>Severity:       critical
>Priority:       high
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Fri Jul 17 08:00:15 UTC 2009
>Closed-Date:
>Last-Modified:
>Originator:     O. Hartmann
>Release:        FreeBSD 8.0-BETA2/FreeBSD 7.2-STABLE
>Organization:
FU Berlin
>Environment:
>Description:
PostgreSQL >= 8.3 seems to have renamed the charsetencoding UNICODE to UTF8. This is not reflected by the actual port of libdbi-drivers, but there are actually patches made by M. Hoenicka residing at sourceforge.

Using PostgreSQL >= 8.3 in combination with ports/textproc/refdb (which has libdbi-drivers as dependency) results in a non-operating refdb-system since the refdbd doens't know how to handle 'UTF-8', which needs to be mapped as 'UTF8' by the libdbi-driver/pgsql.

The patch is simple, I added a line in drivers/pgsql/dbd_pgsql.c. Maybe the maintainer would please have a look on the several fixes that already have been made by the development crew including this one I mention made by M. Hoenicka (he solved this issue while we have had personal communication).
>How-To-Repeat:
Build textproc/refdb with databases.postgresql8[34]-server|client with actual databases/libdbi-drivers. Then fill up the refdb-tables in PostgrSQL with the testdata and try to retrieve references with 'getref'. This will never succeed until you patch libdbi-drivers as mentioned.
>Fix:
Apply appended patch.

Patch attached with submission follows:

--- drivers/pgsql/dbd_pgsql.c.orig	2009-07-16 17:11:32.000000000 +0200
+++ drivers/pgsql/dbd_pgsql.c	2009-07-16 17:11:48.000000000 +0200
@@ -75,6 +75,7 @@
   "EUC_JP", "EUC-JP",
   "EUC_KR", "EUC-KR",
   "UNICODE", "UTF-8",
+  "UTF8", "UTF-8",
   "LATIN1", "ISO-8859-1",
   "LATIN2", "ISO-8859-2",
   "LATIN3", "ISO-8859-3",


>Release-Note:
>Audit-Trail:
>Unformatted: