MySQL Forums
Forum List  »  Newbie

MySQL GROUP BY does nog make a difference upper- and power cases?
Posted by: Nico Kamp
Date: April 26, 2017 12:42PM

Hello,

When I do for example:
Select field_x
From table;

Then two records are returned:
VALUE OG and Value OG

But if change the query like thuis:
Select field_x
From taboe
Group by field_x;

Then only ons row is returned:VALUE OG, only in uppercase. MySQL wees no difference between VALUE OG and VALUE OG. SQL Server and Oracle make a difference between uppe- and lowercase.

Why does MySQL nog make a difference between uppercase and lowercase characters at a group by?

Is there a Work around for? Or how van i solve thuis?

Thanks

Nico

Options: ReplyQuote


Subject
Written By
Posted
MySQL GROUP BY does nog make a difference upper- and power cases?
April 26, 2017 12:42PM


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.