hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : MySQL case sensitivity
Reply

Forum Jump

MySQL case sensitivity

Reply Post New Thread In Hosting Security and Technology Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 03-09-2004, 02:18 PM
JTY JTY is offline
Community Guide
 
Join Date: Jun 2000
Location: Washington, USA
Posts: 5,991
Cool

MySQL case sensitivity


Anyone have a work-around for case sensitive database and table names?

E.g. you can reference the database in both upper and lower case.

For reference the server is running FreeBSD and it's MySQL version 3.23.56

Reply With Quote


Sponsored Links
  #2  
Old 03-09-2004, 02:44 PM
dan_erat dan_erat is offline
Web Hosting Master
 
Join Date: Jun 2003
Posts: 673
Check out this page from the MySQL docs. There is a lower_case_table_names options to control this (dunno if it's supported in 3.23). If you set it to 1, you will need to stop MySQL and rename your files and directories to lowercase first.

Reply With Quote
  #3  
Old 03-09-2004, 02:52 PM
JTY JTY is offline
Community Guide
 
Join Date: Jun 2000
Location: Washington, USA
Posts: 5,991
Thanks!

Reply With Quote
Sponsored Links
Reply

Related posts from TheWhir.com
Title Type Date Posted
Tesora's OpenStack DBaaS Supports MongoDB, Cassandra, Redis, and MySQL Web Hosting News 2014-05-23 14:53:11
Google Releases Hosted Database Service Cloud SQL to General Availability Web Hosting News 2014-02-12 13:46:02
Google Cloud Provides Support For Native MySQL Connections Web Hosting News 2013-11-01 14:36:06
PHP And MySQL Scaling: Preparing A Startup For Growth Blog 2014-04-24 13:27:35
Today in Domains: Startups, Exact Match Keyword Domains and Facebook Typosquatters Blog 2013-05-01 16:35:20


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?