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 Quote Link to comment 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? Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.