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 a

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 build

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-t

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 ful