MySQL: Set case sensitive as default

Question

I am using MySQL on Windows 10.

Is there any way to set case sensitive as default?

To have case sensitivity in any query, whether it's column name or value name.

Column names are never case sensitive on any platform. Values (if you mean that by value names) depend on the definition of your column (e.g. binary would use case sensitive comparison). You can make tablenames (and some other objects) case sensitive, but it is very discouraged on windows (because you can still not have two tables with the same name and might result in some problems). Maybe you should elaborate a bit on what you are trying to achieve. — Solarflare, Jul 19 '17 at 18:33

score 0 · Accepted Answer · answered Jul 19 '17 at 18:23

0

I don't really knows about case sensitive that you meaning above

But I though this answer help you out

answered Jul 19 '17 at 18:23

Flix

1 Answers1