ALT Linux sysadmins discussion
 help / color / mirror / Atom feed
From: "Nikolay A. Fetisov" <naf@naf.net.ru>
To: sysadmins@lists.altlinux.org
Subject: Re: [Sysadmins] MySQL: tables and db case insensitive
Date: Tue, 17 Apr 2007 18:46:41 +0400
Message-ID: <20070417184641.4e37aa9f@naf177.naf.net.ru> (raw)
In-Reply-To: <4624D896.5060100@mail.ru>

On Tue, 17 Apr 2007 18:24:22 +0400
Vladimir Karpinsky wrote:

> Можно ли настроить MySQL под Linux так, чтобы имена баз и таблиц были бы 
> нечувствительны к регистру? Подозреваю, что нет, но очень надеюсь ошибиться.

Да, можно. В /var/lib/mysql/my.cnf, параметр lower_case_table_names.
Поведение MySQL под Windows задаётся через
lower_case_table_names = 1

-- 
С уважением,	
Николай Фетисов


  parent reply	other threads:[~2007-04-17 14:46 UTC|newest]

Thread overview: 5+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2007-04-16 10:28 [Sysadmins] MySQL Vladimir Karpinsky
2007-04-17 14:24 ` [Sysadmins] MySQL: tables and db case insensitive Vladimir Karpinsky
2007-04-17 14:35   ` Ivan Fedorov
2007-04-17 14:46   ` Nikolay A. Fetisov [this message]
2007-04-18  4:24     ` Vladimir Karpinsky

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=20070417184641.4e37aa9f@naf177.naf.net.ru \
    --to=naf@naf.net.ru \
    --cc=sysadmins@lists.altlinux.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link

ALT Linux sysadmins discussion

This inbox may be cloned and mirrored by anyone:

	git clone --mirror http://lore.altlinux.org/sysadmins/0 sysadmins/git/0.git

	# If you have public-inbox 1.1+ installed, you may
	# initialize and index your mirror using the following commands:
	public-inbox-init -V2 sysadmins sysadmins/ http://lore.altlinux.org/sysadmins \
		sysadmins@lists.altlinux.org sysadmins@lists.altlinux.ru sysadmins@lists.altlinux.com
	public-inbox-index sysadmins

Example config snippet for mirrors.
Newsgroup available over NNTP:
	nntp://lore.altlinux.org/org.altlinux.lists.sysadmins


AGPL code for this site: git clone https://public-inbox.org/public-inbox.git