Fwd: Table names case sensitivity

2002-02-04 Thread Mr Kent Cheung
rom: Mr Kent Cheung <[EMAIL PROTECTED]> > Subject: Table names case sensitivity > To: MySQL Discussion <[EMAIL PROTECTED]> > > Dear MySQL community, > > I am new MySQL user. I want to migrate a M$ SQL > Server > database to MySQL in a Linux box. Since table names &

Fwd: Table names case sensitivity

2002-01-31 Thread Egor Egorov
Mr, Thursday, January 31, 2002, 12:29:24 PM, you wrote: MKC> Hi, MKC> As what I described in the original text, I have MKC> changed the table names to lower cases. Thus, I think MKC> I have done exactly what the manual says. Is this a MKC> bug or what have I missed? You have grants on database

Fwd: Table names case sensitivity

2002-01-31 Thread Mr Kent Cheung
u, 31 Jan 2002 12:12:01 +0200 > To: [EMAIL PROTECTED] > From: Egor Egorov <[EMAIL PROTECTED]> > Subject: Table names case sensitivity > > Mr, > > Thursday, January 31, 2002, 6:01:21 AM, you wrote: > MKC> Dear MySQL community, > > MKC> I am new MySQL user. I w

Table names case sensitivity

2002-01-31 Thread Egor Egorov
Mr, Thursday, January 31, 2002, 6:01:21 AM, you wrote: MKC> Dear MySQL community, MKC> I am new MySQL user. I want to migrate a M$ SQL Server MKC> database to MySQL in a Linux box. Since table names in MKC> MySQL@Linux is case sensitive, I am having troubles MKC> connecting to the server via ODB

RE: Table names case sensitivity

2002-01-31 Thread Mr Kent Cheung
Neil, Thank you for your suggestion. Unfortunately, the Grant command grants privileges to lower case table names also. I have also tried to find solution from archive of mysql mail lists but nothing useful have been found. Kent. --- Neil Silvester <[EMAIL PROTECTED]> wrote: > > -Original

Table names case sensitivity

2002-01-30 Thread Mr Kent Cheung
Dear MySQL community, I am new MySQL user. I want to migrate a M$ SQL Server database to MySQL in a Linux box. Since table names in MySQL@Linux is case sensitive, I am having troubles connecting to the server via ODBC from a Windows box. I search the documentation and find that I may be able to