xampp and mysql all columns in table are lower case in php

Question

If I print_r($object) I get:

Array ( [id] => 1 [ime] => rwe [letnica] => 0 [mesec] => 1 [datoteka] => [disciplineid] => 2 [rangtekmovanjaid] => 3 )

My DB columns are:

- disciplineId
- rangtekmovanjaId

I set lower_case_table_names=0 in my.ini for mysql 5.0 part of xampp but is the same. What is wrong?

nerdess · Accepted Answer · 2011-12-21 09:40:30Z

11

To fix this on XAMPP go to your my.ini file (e.g. inside C:\xampp\mysql\bin) and find the [mysqld] area.

Add to it the following line:

lower_case_table_names=0

restart your apache & mysql

now your table names are case sensitive even on a windows system.

answered Dec 21, 2011 at 9:40

nerdess

11k11 gold badges51 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Wh1T3h4Ck5 · Accepted Answer · 2011-04-14 07:53:54Z

1

According to MySQL manual

You should NOT set this variable to 0 if you are running MySQL on a system that has case-insensitive file names (such as Windows or Mac OS X). If you set this variable to 0 on such a system and access MyISAM tablenames using different lettercases, index corruption may result. On Windows the default value is 1. On Mac OS X, the default value is 2.

MySQL: Identifier Case Sensitivity

In MySQL, databases correspond to directories within the data directory. Each table within a database corresponds to at least one file within the database directory (and possibly more, depending on the storage engine). Consequently, the case sensitivity of the underlying operating system plays a part in the case sensitivity of database and table names. This means database and table names are not case sensitive in Windows, and case sensitive in most varieties of Unix. One notable exception is Mac OS X, which is Unix-based but uses a default file system type (HFS+) that is not case sensitive.

more

By default, table aliases are case sensitive on Unix, but not so on Windows or Mac OS X.

That means, on Linux servers (Unix) table/column name "Test" is not equal with "test", "TEST", "tESt", etc. by default.

edited Apr 14, 2011 at 7:53

answered Apr 14, 2011 at 7:37

Wh1T3h4Ck5

8,52910 gold badges63 silver badges82 bronze badges

2 Comments

senzacionale Over a year ago

but if i move page from win to linux then everything stop working becouse column name is "rangtekmovanjaId" and in php i must use "rangtekmovanjaId" not "rangtekmovanjaid" like in windows. So how can i make in windows "rangtekmovanjaId" filed in mysql itentical to "rangtekmovanjaId" in php and not like "rangtekmovanjaid"

Wh1T3h4Ck5 Over a year ago

@senzacionale - No, it's not PHP... MySQL causes problems. Above, in first quotation you'll find

If you set this variable to 0 on such a system and access MyISAM tablenames using different lettercases, index corruption may result.

, I don't know any other solution then to rewrite all your table names to lowercase extension. I've faced similar problem year ago and since than, I'm using lowercase only for everything in PHP and MySQL.

Collectives™ on Stack Overflow

xampp and mysql all columns in table are lower case in php

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related