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

Uppercase Problem

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Uppercase Problem

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • January 30, 2007 at 11:42 pm #10154
      WyleySam
      Member

      When I try to create a table that has uppercase characters SQLyog converts them to lowercase. The only way to get uppercase is to go to the data directory in the MySQL installation directory and change the name there.

    • January 31, 2007 at 5:42 am #23314
      peterlaursen
      Participant

      “When I try to create a table that has uppercase characters SQLyog converts them to lowercase.”

      NO!!! Absolutely NO!!! The MySQL server does!

      “The only way to get uppercase is to go to the data directory in the MySQL installation directory and change the name there.”

      My advice: do not mess around with MySQL this way!

      You should set the “lower_case_table_names” system variable = 2 in server configuration!

      refer to: http://dev.mysql.com/doc/refman/5.0/en/ide…ensitivity.html

      However also read this:

      http://webyog.com/faq/35_25

      … there is a bug with some MySQL versions affecting InnoDB tables when the server is running on Windows!

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.