MySQL, UTF8 and collations

Hey, We're upgrading MySQLs from 5.0 to 5.5, and running into the predictable utf8_general_ci bu^Wwe-meant-to-do-that with german ß and similar characters. The server swallowed the existing datafiles (thank god for that) so we're up and running, but check table does whine about needing a full

Re: Having trouble with SQL query

Hi Nitin Thanks - I tried that and got 0 rows... I have spent more time on describing my problem -- see below hopefully this will make the issue more clear... Rich I have a MySQL database with a menu table and a product table. - The products are linked to the menus in a one-to-many

Re: Having trouble with SQL query

Hello Rich, On 8/27/2012 12:19 PM, rich gray wrote: Hi Nitin Thanks - I tried that and got 0 rows... I have spent more time on describing my problem -- see below hopefully this will make the issue more clear... Rich ... snip ... There are many resources out there that can tell you how to

RE: MySQL, UTF8 and collations

There is a section on German Sharp-s in http://mysql.rjweb.org/doc.php/charcoll I agree with dirty. As I understand it, about 5.1.24, they said Oops, sharp-s is collated wrong, let's fix it. The fix broke things, but they stuck by the correct sorting. Eventually they said Oh, let's add