Preserving case on Win32 table names

Astra

Hi All

Found that when I executed my DDL script on a Win32 installation of MySQL
(v4.0.18) it converted all of my table names to lowercase.

The problem was that after I had filled the newly created DB with content,
backed it up and then restored it into my ISP's unix version of MySQL my web
app couldn't use any of the tables because I was querying them in UCase and
all of the tables were in LCase.

Thinking this was a fault with the MySQL Admin prog, I reported it as a bug,
but then after their support found that it was my Win32 installation that
was causing the LCase issue they wouldn't go into depth on the best method
to make my Win32 installation leave the case alone.

All I have from them is that I should specify the
lower_case_tabl e_names='xx' command, but I don't if I should:

a) Put this command somewhere in my 'my.ini' file. If so, where?

b) What parameter should I specify for 'xx' to ensure that the above will
work OK. A couple of horror stories on the
http://dev.mysql.com/doc/mysql/en/na...nsitivity.html page stated
that if you get this wrong you could corrupt various areas of your DB.

Your help would be very much appreciated.

Rgds

Robbie

Jul 23 '05 #1

Subscribe Reply

1809

Jeff Paffett

It's generally best to leave the table names in lower case, because of
this problem. I don't know of many PHP projects that use UC table names.

Astra wrote:

Hi All

Found that when I executed my DDL script on a Win32 installation of MySQL
(v4.0.18) it converted all of my table names to lowercase.

The problem was that after I had filled the newly created DB with content,
backed it up and then restored it into my ISP's unix version of MySQL my web
app couldn't use any of the tables because I was querying them in UCase and
all of the tables were in LCase.

Thinking this was a fault with the MySQL Admin prog, I reported it as a bug,
but then after their support found that it was my Win32 installation that
was causing the LCase issue they wouldn't go into depth on the best method
to make my Win32 installation leave the case alone.

All I have from them is that I should specify the
lower_case_tabl e_names='xx' command, but I don't if I should:

a) Put this command somewhere in my 'my.ini' file. If so, where?

b) What parameter should I specify for 'xx' to ensure that the above will
work OK. A couple of horror stories on the
http://dev.mysql.com/doc/mysql/en/na...nsitivity.html page stated
that if you get this wrong you could corrupt various areas of your DB.

Your help would be very much appreciated.

Rgds

Robbie

Jul 23 '05 #2

Similar topics

538

Lower case MySQL table names on Windows Server 2003....

by: David | last post by:

Hi, I currently administer our MySQL db version 3.23.56 on a Linux Cobalt Qube server via an external fron-end piece of software. My Table Names have capital letters at the beginning, i.e. StockMovements, OrderLines..... We are now implementing a cross-over to a Windows Server 2003 machine. I have installed MySQL version 4.0.20a and initially it was stated as 4.0.20a-debug. I managed to find another piece of software to take it

MySQL Database

1558

case sensative issues?

by: Peter Kellner | last post by:

I notice that on unix the default for case sensative is off which means tables created with upper case need to be referenced in sql as upper case. It seems that if the case sensative variable is set to 1, then select emp works as well as select EMP. Is there any reason not to set it to 1? Also, is there an ansi standard for this? I could not find a reference to one. Thanks, -Peter

MySQL Database

5144

integral promotion, arithmetic conversion, value preserving, unsigned preserving???

by: TTroy | last post by:

Hello, I'm relatively new to C and have gone through more than 4 books on it. None mentioned anything about integral promotion, arithmetic conversion, value preserving and unsigned preserving. And K&R2 mentions "signed extension" everywhere. Reading some old clc posts, I've beginning to realize that these books are over-generalizing the topic. I am just wondering what the difference between the following pairs of terms are: 1)...

C / C++

2366

PG case sensitivity

by: Christian Sell | last post by:

Hello, I am running into a problem with PGs case sensitivity with regard to column and table names. I am using program components that require the object names returned from database metadata queries to be in uppercase. Therefore, I am forced to use double quotes in the table creation scripts, like create table "BLA" (); However, after doing that, all scripts that reference objects without quotes

PostgreSQL Database

2984

[API] Win32 Resources - List Icon Resource Names

by: Mythran | last post by:

I wrote some code that is supposed to enumerate through the specified file's win32 resources and return a string-array of all icon names. When it runs, it returns a string-array with a bunch of numbers in sequential order (1-55 when ran against iexplore.exe). When I open up iexplore.exe in Visual Studio, I see 23 icons. Each icon has 1 or more sizes of the icon...I'm assuming that there are, in fact, 55 icon resources in iexplore.exe,...

C# / C Sharp

10300

Mixed Case in table and column names.

by: natG | last post by:

Hi; I am transferring data from MySql to db2 using my own java/jdbc program. Working out ok, except for the fact that our apps use mixed-case names for tables and columns. Although my CREATE TABLE commands issued via jdbc uses mixed case for the names, db2 insists on using only upper case. (This also happens from the CLP or DB2CC, but my concern is for it to work via jdbc.) Is there a simple setting at the database level to allow mixed...

DB2 Database

4264

case sensitivity in 9i & 10g

by: Anita Potekkat | last post by:

Hello, I had a question regarding Case Sensitivity in 10g & 9i. (1) Does Case Sensitivity in Oracle have to do with data only? Or does it also effect table & column names? For e.g. in a table NAMES with column NAME are the following queries equivalent regardless of whether case sensitivity is turned on or off. select name from names; select NAME from names; select name from NAMES; select NAME from NAMES;

Oracle Database

3303

Sign preserving Vs value preserving

by: sophia.agnes | last post by:

Dear all, I was going through the book "C a software engineering approach by darnell & Margolis" there was a section named sign preserving vs value preserving it is as follows sign preserving rule:- when signed and un signed objects meet in an expression, the result is

C / C++

1856

Preserving Relationship window

by: Phil Stanton | last post by:

Having spent ages sorting out the layout of my relationship window with about 60 tables and getting it all tidy and with enough of the tables visible to show the PK an FK relaionshipsOn a subseqent occassion, on opening the relationship window, I found all the tables had shrunk so that in most cases, only the table names were visible and the fields could only be seen by "expanding" the table again. I know you can print out the relationship...

Microsoft Access / VBA

9541

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10484

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10228

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

10027

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7565

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6805

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5463

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5585

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2938

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General