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

Case Sensitive Problem

forums forums SQLyog SQLyog: Bugs / Feature Requests Case Sensitive Problem

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • #16232
      CalEvans
      Member

      Hi,

      This is an issue with mysql on windows, not with sqlyog. It's been discussed here before.

      =C=

      p.s., It's not an issue with mysql on any other platform.

    • #16233
      Shadow
      Member

      As of now, Windows does not differentiate between cases in file names meaning that “filename.frm” and “FileName.frm” names yield to the same file. Currently MySql databases are “stored” as folders and tables as files (even when InnoDB is used!), so naming is affected by how the OS stores their names. This is why you have only lowercased db and table names on Windows.

      Besides, there is a setting in MySql called lower_case_table_names. On Windows this value defaults to 1 (true). If this value is set to this value, then your table names will be always in lower case regardless of you OS.

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