Database charset/collation problem

Our problem is text from a database not showing up in textfileds on a webpage. The information is entered via oempro from octeth (with User Interface Character set set to "Norwegian"). -MySQL System Variables character_set_client latin1 character_set_connection latin1 character_set_database latin1 character_set_filesystem binary character_set_results latin1 character_set_server latin1 character_set_system utf8 character_sets_dir /usr/share/mysql/charsets/ collation_connection latin1_swedish_ci collation_database latin1_swedish_ci collation_server latin1_swedish_ci -mySQLAdmin localhost info MySQL charset: UTF-8 Unicode (utf8) MySQL connection collation: latin1_swedish_ci The database containing the data has collation: latin1_swedish_c1 We need someone who can fix this problem within a couple of days. This should be a quick fix!