Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    144

    Unanswered: lower_case_table_names effect on VIEWS

    hi
    i just set lower_case_table_names=2 in my.ini on widows os, now my table names are case-sensetive, but is it suppose to work on views name as well? because my views are still in lowercase i want them case-sensetive too.
    is there any other option for views?

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    This parameter is only applicable to tables and databases. To make a view cases sensitive create the view as follows:

    CREATE VIEW `view_name` AS SELECT ...

    Keeping the view name inside `` and in lower case may help you here?
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

  3. #3
    Join Date
    May 2004
    Posts
    144
    Quote Originally Posted by it-iss.com View Post
    Keeping the view name inside `` and in lower case may help you here?
    no, put view name inside `` didn't work out.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •