2 messages in com.mysql.lists.bugsRE: WIN32 CASE
FromSent OnAttachments
Steve Ruby10 Feb 2001 11:21 
Chris Bolt10 Feb 2001 19:28 
Subject:RE: WIN32 CASE
From:Chris Bolt (chr@bolt.cx)
Date:02/10/2001 07:28:31 PM
List:com.mysql.lists.bugs

The variable lower_case_table_names is set to 1 by default on win32 now. Set it to 0 for the old behaviour.

Mysql 3.22.x win32 version used to respect table case on CREATE table... It no longer does...

As we go back and forth between HP-UX, Linux and Win32 with mysql this case issue is likely to be the only thing that will stop us from a smooth transition to 3.23.

PROBLEM:

create table TEST (id int); on win32 creates a table called test... If the database is dumped and then copied to a UNIX machine none of the code will work because all code (JDBC, etc) is expecting TEST.

This used to be a non issue with 3.22.. Even tables copied from 3.22. to 3.23. system retain case until you try altering them in any way.

HOW TO FIX:

We would have to change many code bases to use all lowercase table names on win32 and unix systems.

Is there any chance that this behaviour can go back to the old on WIN..?

--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs@lists.mysql.com To unsubscribe, e-mail <bugs@lists.mysql.com>