On Wednesday, November 24, 2004, 9:23:09 PM, David wrote:

> Jamis Buck had an example from Oracle also being case sensitive, so it
> seems to be somewhat more widespread than just MySQL. And as I said,
> Active Record was founded on MySQL, so when behavior differs between
> RDBMS, AR will side by MySQL by default (strong pressures might revert
> that default, but I don't think this is a strong pressure).

I was suprised with Jamis's Oracle examples; I always thought Oracle
was case-insensitive up the wazoo.  But I guess I never tried quoting
table names etc. (yeah, *that's* intuitive...)

Also, I was surprised by Austin's use of Sybase to back up the "SQL
databases are case-insensitive" claim.  When I worked with Sybase ~6
years ago, it was certainly case-sensitive.  The meme in the office at
the time was that Sybase was different from most other DBs in this
regard, and we had to be careful about this when migrating data.

Gavin