From: Catherine <jes@hppi.troitsk.ru> To: ALT Linux sysadmin discuss <sysadmins@lists.altlinux.org> Subject: Re: [Sysadmins] Проблема с MySQL ( ручной ввод ) в Desktop 4.0 Date: Thu, 13 Sep 2007 00:19:40 +0400 Message-ID: <200709130019.40451.jes@hppi.troitsk.ru> (raw) In-Reply-To: <46E844F6.7050001@gmail.com> В сообщении от Wednesday 12 September 2007 23:58:46 Andrew Kornilov написал(а): > Catherine wrote: > > Доброе время суток! > > [mysqld] > > default-character-set=cp1251 > > default-collation="cp1251_general_ci" > > init-connect="SET CHARSET cp1251" > > init-connect="SET NAMES cp1251" > > С MySQL всегда было много вопросов с кодировками. > Вот с таким конфигом: > [mysqld] > init-connect="SET NAMES cp1251" > default-character-set=cp1251 > character_set_server=cp1251 > collation_server=cp1251_general_ci > skip-character-set-client-handshake СПАСИБО БОЛЬШОЕ! у меня не было вашей последней строчки в конфиге и без неё не работало! > > и mysql --default-character-set=cp1251 <file.sql > > Все заливается и отображается корректно. > Если в самом файле есть =latin1, советую их тоже заменить на cp1251, > иначе поведение не гарантирую :) > _______________________________________________ > Sysadmins mailing list > Sysadmins@lists.altlinux.org > https://lists.altlinux.org/mailman/listinfo/sysadmins
next prev parent reply other threads:[~2007-09-12 20:19 UTC|newest] Thread overview: 5+ messages / expand[flat|nested] mbox.gz Atom feed top 2007-09-12 19:10 Catherine 2007-09-12 19:58 ` Andrew Kornilov 2007-09-12 20:19 ` Catherine [this message] 2007-09-12 20:36 ` Andrew Kornilov 2007-09-13 5:28 ` Veaceslav Grecea
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=200709130019.40451.jes@hppi.troitsk.ru \ --to=jes@hppi.troitsk.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