i have a back end tool to insert update data into a db.
String fields in mySQL tables are set to latin1_swedish_ci .
The web editor enters data from his PC.
And here's the problem.... I noticed he has set his browser to charset encoding ISO-8859-1, and as most editors do, he copy and paste from Word the text... or from pdf
This cause having not viewable chars in the DB, having those strange symbols...
and the problem is presented also at view time in the browser if it is set on UTF8...
ideas:
should i set the encoding type to UTF8 via meta TAG, for those pages intended for input insert data into DB?
should i use utf8 decode to view (i hope not)...?
what's the common approach/set up to turn around this kind of problems?
