From: Alexey Morsov <samurai@ricom.ru>
To: ALT Linux sysadmin discuss <sysadmins@lists.altlinux.org>
Subject: [Sysadmins] MySQL order by and charset
Date: Thu, 24 Apr 2008 15:36:59 +0400
Message-ID: <20080424113659.GA8513@ricom.ru> (raw)
[-- Attachment #1: Type: text/plain, Size: 995 bytes --]
Приветствую,
Не могу заставить MySQL (5) сортировать по русские буквы по алфавиту. Т.е.
надо скажем сортировать по полю Name - где русские имена. Получаю кашу
какую-то.
В my.cnf
collation_server=utf8_bin
default-character-set=utf8
character_set_server=utf8
таблицы создались (загружен дамп из 4ой версии с предварительным iconv) с
ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin
Куда ему еще можно хвост накрутить? Это ж издевательство какое-то 2008 год
сортировать так и не научили этот мускуль.
--
WBR,
Alexey Morsov
программист ЗАО "ИК "Риком-Траст"
Jabber: samurai@www.fondmarket.ru
ALT Linux Team Member
<php-coder> ГУГЛ реальная вещь!
[-- Attachment #2: Digital signature --]
[-- Type: application/pgp-signature, Size: 481 bytes --]
reply other threads:[~2008-04-24 11:36 UTC|newest]
Thread overview: [no followups] expand[flat|nested] mbox.gz Atom feed
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=20080424113659.GA8513@ricom.ru \
--to=samurai@ricom.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