Re: Newby needs some help - collation/charset ?
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.
Subject
Written By
Posted
December 14, 2013 01:08PM
Re: Newby needs some help - collation/charset ?
December 15, 2013 04:19AM
December 16, 2013 05:25PM
December 16, 2013 07:35PM
December 16, 2013 08:48PM
December 16, 2013 10:07PM
December 17, 2013 05:19PM
December 18, 2013 01:02AM
December 18, 2013 01:36PM
December 18, 2013 03:34PM
December 18, 2013 05:10PM
December 18, 2013 05:37PM
December 18, 2013 06:28PM
December 20, 2013 01:09PM
December 20, 2013 03:24PM
December 20, 2013 03:37PM
December 20, 2013 06:59PM
December 20, 2013 09:20PM
December 21, 2013 12:55AM
December 21, 2013 01:31AM
December 21, 2013 02:12AM
December 21, 2013 02:49AM
December 21, 2013 01:11PM
December 22, 2013 04:04PM
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.