[PHP] Database output is nonsense?

PHP
1

Hello All,

I am building a file hosting site, wich is using a database to store information from the files being uploaded.

Everything seems to work fine, except for the comments. They all print as complete nonsense, though they are fine in the database.

This is shown by the database:

Thanks for the upload, works well!

This is printed to the page:
=ω,
´â, -05-23 -Èâ, øã, Àã, ä, „ã, Err=-|

I am outputting it before any formatting (actually a die statement straight after getting the info from the database) and it only affects the comments, all other file info is printed just fine.

What is wrong??

You can see an example here:
http://rapiddowner.com/test

And this is my database


CREATE TABLE IF NOT EXISTS `files` (
  `id` int(11) NOT NULL auto_increment,
  `short_name` varchar(255) NOT NULL,
  `fulltitle` varchar(255) NOT NULL,
  `filetype` varchar(255) NOT NULL,
  `uploader_name` varchar(255) NOT NULL,
  `dateuploaded` datetime NOT NULL,
  `times_downloaded` int(11) NOT NULL,
  `filedetails` text NOT NULL,
  `comment1_name` varchar(255) NOT NULL,
  `comment1_date` date NOT NULL,
  `comment1_tekst` text character set armscii8 collate armscii8_bin NOT NULL,
  `comment2_name` varchar(255) NOT NULL,
  `comment2_date` date NOT NULL,
  `comment2_tekst` text NOT NULL,
  `comment3_name` varchar(255) NOT NULL,
  `comment3_date` date NOT NULL,
  `comment3_tekst` text NOT NULL,
  `comment4_name` varchar(255) NOT NULL,
  `comment4_date` date NOT NULL,
  `comment4_tekst` text NOT NULL,
  `clicks` int(11) NOT NULL,
  `conversions` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
2

Try setting the collation for that field to utf8_general_ci.
And, think about database <-> web server traffic to transfer the data from the database server to the web server when someone wants to download a specific file.
That traffic is alot of overhead, while you could save the file locally on the web server, and just use a reference in the database.