mysql/win2k/ can't capitalize tables

Anon

I create a table in mysql example;

create table BIGHUNKINTABLE (Id, (INT));

and what do you know: Its converted to
all lower case:

bighunkintable

this only happens in my Win2k install.

What's up?

I hope someone knows - or I start cuttin' fingers.

~ Dan

Anon

First of Win2k is a "case-insensitive" OS and SQL doesn't care about upper case except when dealing with BLOB. It's quite logical why this is so. If you have two tables BlueHats and bluehats it causes confusion easily. If you don't believe this is true try to make another table with same name with different case type. MySQL rejects it and gives you an error.

Anon

Neverthless,

Its a bug in mysql for Windoze that I cannot make a table name anything but lowercase.

In Linux my table are all caps. but when I use the same create statements in mysql it creates them as lowercase.

It doesn't convert any other names, columns and data stay with the same case as they are defined in the statement. Just table names.
No matter what i do they revert to lowercase.

It does not affect my application except that i use the same mysql database structure back and forth between linux/mysql and win2k/mysql and restore from the same backup files. I can change my table names to lowercase but this should be unneccessary.

~ DM

Anon

You must understand that the "user friendly" win32 OS incorporated case-insensitivity because of consumer complaints that UNIXes where to difficult to use and that UNIXes were only for "Computer People" not "Average User". With that Bill Gates become very rich and inherited his thrown. Now on to MySQL. The data that you enter into your rows may have capitalization but, your query for example...

INSERT INTO TABLE VALUES();
is seen as ...

insert into table values();

as you work with PHP you'll see this with the function " sql_regcase() "

if you do a select statement on a table with BLOB fields everything is case-sensitive.

Finally, your table naming conventions seem to default to your OS's case-sensitivity conventions.

Happy Coding!