Member Avatar for Dani

What's the difference between LCASE() and LOWER() in MySQL?

I found places on the web that said they're similar but not a synonym for each other, so I'm not sure what the differences are?

  • 2 Contributors
  • 1 Reply
  • 4K Views
  • 33 Minutes Discussion Span
  • Latest Post Latest Post by pty
Member Avatar for pty

They are synonymous, if you check the official docs it says as much. The reason they're both there is for familiarity, SQL Server and DB2 use lcase, Oracle and PostgreSQL use lower.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.