set names, weird characters - just cant get it right
Posted: Mon Jan 04, 2010 11:48 am
Hi folks,
Sometime when I import mysql data and use it with CMSMS I just get weird characters. I know it has something to do with character set and collation. I have tried changing the collation, using SET NAMES and changing the settings in config.php. But I just can't it right. When I'm in phpmyadmin and I use SET NAMES latin1; {SQL Command} it shows the right characters, but no mather what I try, it wont work in my module. No mather what my collation is, latin1 or utf8 I still get strange characters.
Can someone please help me?
Sometime when I import mysql data and use it with CMSMS I just get weird characters. I know it has something to do with character set and collation. I have tried changing the collation, using SET NAMES and changing the settings in config.php. But I just can't it right. When I'm in phpmyadmin and I use SET NAMES latin1; {SQL Command} it shows the right characters, but no mather what I try, it wont work in my module. No mather what my collation is, latin1 or utf8 I still get strange characters.
Can someone please help me?