Web Wiz Forums - CAPS problem - MySQL to MySQL migration

Print Page | Close Window

CAPS problem - MySQL to MySQL migration

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=22846
Printed Date: 08 April 2026 at 2:52am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: CAPS problem - MySQL to MySQL migration

Posted By: neoplof
Subject: CAPS problem - MySQL to MySQL migration
Date Posted: 06 March 2007 at 5:38pm

Hi,

I am migrating the database to a MySQL server - linux - to gain response.

WWF is already working with a MySQL version, but the MySQL database is installed in the windows server with the forum app.

The linux server for MySQL only recognizes Lower caps for the table names (at least mine), which means that I have to change any SQL reference to any table name in the forum to lower case.

i.e. this wouldnt work: "select tblCategory"

i.e. this wouldwork: "select tblcategory"

The question: Is there any page in which the forum SQLs are stored, or Do I have to check for every forum page to see if it has an SQL sentence to lower case it?

I hope I have explained myself corectly.. thanks for the help.