ports/92604: mysql41-client broken with non-default character set

[Blaz Zupan]

>Number:         92604
>Category:       ports
>Synopsis:       mysql41-client broken with non-default character set
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          maintainer-update
>Submitter-Id:   current-users
>Arrival-Date:   Tue Jan 31 13:10:02 GMT 2006
>Closed-Date:
>Last-Modified:
>Originator:     Blaz Zupan
>Release:        FreeBSD 5.4-RELEASE i386
>Organization:
>Environment:

	
>Description:

The databases/mysql41-client and probably databases/mysql50-client don't
work correctly on a machine where only the client port is installed and you
set the character set with WITH_CHARSET and/or WITH_XCHARSET.

>How-To-Repeat:

Install databases/mysql41-server on a server and databases/mysql41-client on
the client machines. Both should be compiled with WITH_CHARSET=latin2 and
WITH_XCHARSET=all. Try to run a query on the client by connecting to the
server. Here is an example notice from a PHP script running on the client:

Warning: mysql_connect() [function.mysql-connect]: Can't initialize
character set latin2 (path: /usr/local/share/mysql/charsets/) in
somescript.php on line 16

>Fix:

Temporary workaround is to install the mysql41-server port on the client
machine. The correct fix is to move the installation of
/usr/local/share/mysql/charsets from mysql41-server to mysql41-client.
>Release-Note:
>Audit-Trail:
>Unformatted: