in reply to CGI MySQL insert/update special characters
Probably all you need is to start with use CGI -utf8; to decode binary data in parameters to characters; CGI has info about what it does. But that does assume your DB is correct, which is rarely the case with default MySQL, and I believe there is a security issue with file uploads if you’re not careful with that default but I can’t cite it. *Every* part of the interchange has to be right and guessing or just trying to patch stuff in one point is a losing game. Try to pick up as much as you can out of tchrist’s canonical answer to these issues: https://stackoverflow.com/a/6163129/109483.
|
|---|