Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Changing Case

forums › forums › Changing Case

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • March 9, 2006 at 7:20 pm #9527
      rtk
      Member

      I want to change the case of data in a field from UPPERCASE to Proper Case?

      Is there a easy way to do this in MYSQL? I couldn't find anything in a quick web search.

    • March 9, 2006 at 11:04 pm #20830
      peterlaursen
      Participant

      It depends on the directive lower_case_table_names in the mysql configuration.

      If this is = 0 (as most often on *nix) a simple rename table will do. if it is 1 then of course not possible. If it is 2 (as most often on Windows and MAC) you can use this trick (use 2 'rename tables'):

      CODE
      rename table `test`.`t1` to `test`.`dummy`;

      rename table `test`.`dummy` to `test`.`T1`;

    • March 11, 2006 at 5:40 am #20831
      Ritesh
      Member

      I think MySQL is case sensitive by default in Linux.

    • March 11, 2006 at 9:20 am #20832
      peterlaursen
      Participant

      QUOTE
      I think MySQL is case sensitive by default in Linux.

      Sure. If lower_case_table_names directive is omittted in configuration file it takes its value from lower_case_file_system. As 99.9 % of *nix (except for Mac) uses a case-sensitive file system and as most peple don't change the default, that is the way it is.

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.