Welcome Guest, Not a member yet? Register   Sign In
MySQL Query not working (Case sensitive issue)
#4

[eluser]rich.a.coy[/eluser]
Perfect, Thanks! I changed the field to utf8_unicode_ci and now it works as expected.

Are there any disadvantages of utf8_unicode_ci that I need to know about? This will be a large database (hopefully) and want it to be as optimized as possible. Should I set all text fields to utf8_unicode_ci, or just the ones I plan to search against?

Rich


Messages In This Thread
MySQL Query not working (Case sensitive issue) - by El Forum - 02-01-2010, 03:41 PM
MySQL Query not working (Case sensitive issue) - by El Forum - 02-01-2010, 04:43 PM
MySQL Query not working (Case sensitive issue) - by El Forum - 02-01-2010, 04:43 PM
MySQL Query not working (Case sensitive issue) - by El Forum - 02-01-2010, 04:59 PM



Theme © iAndrew 2016 - Forum software by © MyBB