dennismonsewicz Posted November 2, 2009 Share Posted November 2, 2009 What is the best collation to use when importing french translation into mysql 5.0+? I have tried everything I know and have researched and nothing is working... certain characters are being stripped or not showing up as they should Link to comment https://forums.phpfreaks.com/topic/179901-solved-french-collation-php-import-into-mysql/ Share on other sites More sharing options...
dennismonsewicz Posted November 2, 2009 Author Share Posted November 2, 2009 ok so I fixed my problem... but now when I am trying to load the special chars to the screen they are not being rendered properly... anyway to fix this? Link to comment https://forums.phpfreaks.com/topic/179901-solved-french-collation-php-import-into-mysql/#findComment-949142 Share on other sites More sharing options...
cags Posted November 2, 2009 Share Posted November 2, 2009 You need to ensure the encoding type of the page is correct. You can set this using HTML headers or using the header function. You may also need to set the character set for the mysql connection by using... mysql_query( "SET NAMES utf8"); mysql_query( "SET CHARACTER SET utf8"); ...after connecting to the database. Link to comment https://forums.phpfreaks.com/topic/179901-solved-french-collation-php-import-into-mysql/#findComment-949344 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.