How to set db property so that table name queries are case-insensitive?

How to set db property so that table name queries are case-insensitive?

am 18.03.2009 22:15:58 von davidmichaelkarr

Ubuntu 8.10.

I was experimenting with the Spring Petclinic sample application,
configured with MySQL. I found that some of the tests were failing,
apparently because of table name case-sensitivity issues. I was able to
fix some of the code references, but after that I hit other, probably
for the same issue. The tables were created with lower case names, but
generated queries are using uppercase names. I can't easily control how
it generates the SQL (using Hibernate).

I think I'd prefer to have table names be case-sensitive, but I guess
for now I have to figure out how to disable that, at least for this
database.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: How to set db property so that table name queries are

am 19.03.2009 14:33:32 von Martijn Engler

http://dev.mysql.com/doc/refman/5.0/en/server-system-variabl es.html#sysvar_=
lower_case_table_names

I think you'll want to set it to 1

On Wed, Mar 18, 2009 at 22:15, David M. Karr w=
rote:
> Ubuntu 8.10.
>
> I was experimenting with the Spring Petclinic sample application, configu=
red
> with MySQL. =A0I found that some of the tests were failing, apparently be=
cause
> of table name case-sensitivity issues. =A0I was able to fix some of the c=
ode
> references, but after that I hit other, probably for the same issue. =A0T=
he
> tables were created with lower case names, but generated queries are usin=
g
> uppercase names. =A0I can't easily control how it generates the SQL (usin=
g
> Hibernate).
>
> I think I'd prefer to have table names be case-sensitive, but I guess for
> now I have to figure out how to disable that, at least for this database.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> =A0http://lists.mysql.com/mysql?unsub=3Dmartijn@crystal-labs .nl
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg