How do you write a case insensitive query for both MySQL and Postgres?

by

The moral of this story is: Don’t use a different software stack for development and production. Never.

You’ll just end up with bugs which you can’t reproduce in dev; your testing will be worthless. Just don’t do it.

Using a different database engine is out of the question – there will be FAR more cases where it behaves differently than just LIKE (also, have you checked the collations in use by the databases? Are they identical in EVERY CASE? If not, you can forget ORDER BY on varchar columns working the same)

More Related Contents:

  1. How to select the nth row in a SQL database table?
  2. PostgreSQL GROUP BY different from MySQL?
  3. Change from SQLite to PostgreSQL in a fresh Rails project
  4. What resources exist for Database performance-tuning? [closed]
  5. Remote connect to clearDB heroku database
  6. Foreign key to one of many tables?
  7. Ruby on Rails – cannot load such file — mysql2/2.2/mysql2 (LoadError)
  8. Which DB technology is sued to solve the following search issue? [closed]
  9. MyISAM versus InnoDB [closed]
  10. Compare two MySQL databases [closed]
  11. How should I resolve –secure-file-priv in MySQL?
  12. What does character set and collation mean exactly?
  13. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  14. Storing image in database directly or as base64 data?
  15. Implementation of Levenshtein distance for mysql/fuzzy search?
  16. What’s the difference between MyISAM and InnoDB? [duplicate]
  17. In SQL, is it OK for two tables to refer to each other?
  18. MySQL Install: ERROR: Failed to build gem native extension
  19. How to increase MySQL connections(max_connections)?
  20. MySql views performance [closed]
  21. MySQL: LAST_INSERT_ID() returns 0
  22. How does MySQL Auto Increment work?
  23. Are SELECT type queries the only type that can be nested?
  24. Calculating a Moving Average MySQL?
  25. How to get size of mysql database?
  26. Can I launch a trigger on select statement in mysql?
  27. What is the difference between SQL and MySQL? [closed]
  28. How to Get True Size of MySQL Database?
  29. What are the max number of allowable parameters per database provider type?
  30. MySQL: Computed Column

Leave a Comment