MySQL Forums
Forum List  »  PHP

Re: Newby needs some help - collation/charset ?
Posted by: Barry Galbraith
Date: December 15, 2013 04:19AM

The character set is (sort of) more important than the collation.

Character set tells MySQL what the encoding of the charaters is. Collation tells mysql the "alphebetical order" of the character set.

So, do you have your field set to characterset utf8, so that the collation utf8_general_ci will have the correct characters to order?

Is you webpage submitting utf8 characters? You should find that in the meta settings in the top of your webform.
Is your php script setting the characterset of the connection to mysql? If it using SET NAMES 'utf8' to do it, then it is breaking php's ability to escape your input correctly. It should use mysql_set_charset('utf8') (or equivalent) to do it.

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
Re: Newby needs some help - collation/charset ?
December 15, 2013 04:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.