Web Wiz Support and Community Forums : CAPS problem

Web Wiz Support and Community Forums : CAPS problem - MySQL to MySQL migration https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 01:20:23 +0000 Tue, 06 Mar 2007 17:38:23 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=22846 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[CAPS problem - MySQL to MySQL migration : Hi, I am migrating the database...]]> https://forums.webwiz.net/caps-problem-mysql-to-mysql-migration_topic22846_post121097.html#121097 Author: neoplof
Subject: 22846
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.

]]> Tue, 06 Mar 2007 17:38:23 +0000 https://forums.webwiz.net/caps-problem-mysql-to-mysql-migration_topic22846_post121097.html#121097