Greetings, I'm in need of some guidance. I'm fairly new to *nix but I've been playing with OBSD for the past while. I choose OBSD because I found the project's goals matched what I was looking for and it's superior documentation; Linux docs in general are frustratingly out-dated, inconsistent, incomplete, and/or contradictory. Thank you to all who make OBSD what it is!! I've been lurking long enough to know that those who don't do their research usually get a short terse reply so I've attempted to do mine (FAQ, archive, Google).
The source of my problem is that I want to install Koha open-source Integrated Library System and it currently has some query issues with MySQL 5 but they're also improving character set handling and that requires MySQL 4.1 and UTF-8. OBSD 3.8 and 3.9 have packages for MySQL versions 4.0.24 and 5.0.18 respectively. Can MySQL and Apache provide UTF-8 encoded characters without support in the OS? Does OBSD support UTF-8? From what I've read the answer is probably "no, but it's being worked on". If Yes, then how do I obtain MySQL 4.1 as there doesn't seem to be a package/port. I noticed that there is a binary install at http://dev.mysql.com/downloads/mysql/4.1.html. Would that be the best way or should I compile it from source? I assume I'd also have to install the client and what about the stuff necessary for Perl (?DBI? and ?DBD::MySQL?)? If No, then I could just use MySQL 4.0 with the standard Latin-1 character set and consider converting to UTF-8 in the future. Now how do I go about installing MySQL 4.0 on OBSD 3.9? I've read all about not mixing versions of the OS and Ports/Packages? I thought about installing OBSD 3.8 and MySQL 4.0 first and then upgrading but is there a better way? Looks like MySQL has a binary 4.0 for OBSD 3.9 or is there a trivial way to modify the 3.8 port/package to install on 3.9? Thanks for your time, Mike Dalgity
