Radicore Forum: Bug Reports » Database import

Home » RADICORE development » Bug Reports » Database import

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Database import [message #106 is a reply to message #104]

Thu, 22 June 2006 15:00

AJM
Messages: 2371
Registered: April 2006
Location: Surrey, UK

Senior Member

David Lee wrote on Thu, 22 June 2006 18:30

Using phpmyadmin, I have no difficulty creating a database with both UPPER and lower case characters in the name.

I think I must have the 'lower_case_table_names' option set in MySQL.

Even when I managed to create a database and table names with upper case characters I had no trouble with importing the details as the SQL queries which are generated will work whatever mixture of case is used.

That's another reason why I ABSOLUTELY HATE CASE SENSITIVE SOFTWARE!!!

UPDATE: MySQL is case-insensitive by default, but some non-Windows operating systems can reverse this behaviour. In order to avoid any potential problems you should therefore ensure that the lower_case_table_names variable is set to 1. Please refer to http://dev.mysql.com/doc/refman/4.1/en/name-case-sensitivity .html for details.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

[Updated on: Thu, 22 June 2006 17:22]

Report message to a moderator

[Message index]

		Database import By: David Lee on Wed, 21 June 2006 16:27
		Re: Database import By: AJM on Wed, 21 June 2006 17:24
		Re: Database import By: David Lee on Thu, 22 June 2006 13:30
		Re: Database import By: AJM on Thu, 22 June 2006 15:00
		Re: Database import By: David Lee on Thu, 22 June 2006 14:13

Previous Topic:	Audit_trn task_id field too small
Next Topic:	Possible linux pathname bug

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 28 20:35:07 EST 2024

Total time taken to generate the page: 0.01041 seconds