in reply to datetime insertion problem

I think we'd have to know more about both your environment and the MySQL server's to answer the "Why?". POSIX::strftime honors locale, so the value of $date depends on your LC_foo environment variables. MySQL may be compiled to store utf-8 or some other character encoding.

Question a): I think you should store datetime fields the way MySQL wants, as a datetime column type. Storing them as strings denies you the very useful builtin date & time functions of MySQL. You can retrieve datetimes with MySQL's DATE_FORMAT() function to get most any representation you want. If you have serious encoding problems, you can fall back on unix epoch time for retrieval and then apply localtime.

Question b): Some browsers pretty much ignore http headers. Try specifying the character encoding in the html tag, as well.

After Compline,
Zaxo

Replies are listed 'Best First'.
A reply falls below the community's threshold of quality. You may see it by logging in.