in reply to Re^4: Mysql and Images
in thread Mysql and Images

Hmmm... I've never noticed fragmentation being a source of unreasonable latency in an HTTP environment on a *n(i|u)x machine, but I'll take your word for it. Moving right along:

I would never think to put images into my CGI directory -- they'd live out in the public HTML directory tree somewhere, and if they were coming from untrusted sources that directory would be in a partition mounted with the noexec option. The CGI application, if it has to, should be able to reach into that directory just fine, it being under HTTP document root. I'd still think very seriously about $q -> redirect($image_url); though.

Back to the original problem: Without more information it's impossible to be certain, but if it were mine to fix I'd start by looking at whether or not there's a source of Unicode data in the system, based upon that log line you got when you stuffed a warn into the code.

Replies are listed 'Best First'.
Re^6: Mysql and Images
by Braindead_One (Monk) on Dec 22, 2005 at 07:52 UTC
    Sorry for the late reply ;)
    Ther was indeed some kind of unicode-problem. My Mysql version had Unicode enabled which turned out to be a bad idea. I noticed this when i tried to insert some non-ascii-chars like ä ö ü into the Database. I now recompiled without unicode-support and can now insert those chars without problems, but the select of binary and text-data in 1 query still goes wrong :/.
    Since this project hast to be finished before saturday i'll go with 2 selects for now.
    Thank you for your suggestions!