Date: Fri, 17 Jul 2009 07:53:55 GMT From: "O. Hartmann" <ohartman@zedat.fu-berlin.de> To: freebsd-gnats-submit@FreeBSD.org Subject: ports/136856: databases/libdbi-drivers: PostgreSQL >= 8.3 naming changes of UNICODE -> UTF8 encoding Message-ID: <200907170753.n6H7rt3p026579@www.freebsd.org> Resent-Message-ID: <200907170800.n6H80FNq007107@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>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:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200907170753.n6H7rt3p026579>