I've run into an issue on one of the projects that I'm working on and thought that I'd ping the list to see how others are handling this...
The app accepts form data from the user, runs it through Data::FormValidator to validate it, then stuffs it into our PostgreSQL database. We're expecting users are going to cut/paste from MS-Word and as a result we're going to have to deal with MS "smart quotes". My issue started with a DB error from DBD::Pg telling me that the input had an invalid byte sequence for UTF-8 (the tables in Pg are all encoded as UTF-8). Googling around brought me several possible solutions, but I can't say that I've found one yet that actually -works-. What I'd like the solution to do is: a) provide me a means of encoding/marking the data so that I can insert it into our Pg database without it throwing an error, b) allow viewing of the data to look the same as it did when it was entered. I've tried several things already, setting the Content-Type to "text/html; charset=utf-8" and trying to force the browser to submit the content back as UTF-8, but haven't had any luck yet. Anyone care to chime in with how they're handling this? -- Graham TerMarsch --------------------------------------------------------------------- Web Archive: http://www.mail-archive.com/[email protected]/ http://marc.theaimsgroup.com/?l=cgiapp&r=1&w=2 To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
