From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <dmz@albionbpr.com>
Message-ID: <443D0220.8030907@albionbpr.com>
Date: Wed, 12 Apr 2006 17:35:28 +0400
From: Dmitry Zorin <dmz@albionbpr.com>
Organization: Albion BPR Ltd.
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: ALT Linux Community <community@lists.altlinux.org>
References: <443CF155.7060100@mail.ru>
In-Reply-To: <443CF155.7060100@mail.ru>
Content-Type: text/plain; charset=KOI8-R; format=flowed
Content-Transfer-Encoding: 8bit
Subject: Re: [Comm] MySQL 4.1
X-BeenThere: community@lists.altlinux.org
X-Mailman-Version: 2.1.7
Precedence: list
Reply-To: ALT Linux Community <community@lists.altlinux.org>
List-Id: ALT Linux Community <community.lists.altlinux.org>
List-Unsubscribe: <https://lists.altlinux.org/mailman/listinfo/community>,
	<mailto:community-request@lists.altlinux.org?subject=unsubscribe>
List-Archive: <http://lists.altlinux.org/pipermail/community>
List-Post: <mailto:community@lists.altlinux.org>
List-Help: <mailto:community-request@lists.altlinux.org?subject=help>
List-Subscribe: <https://lists.altlinux.org/mailman/listinfo/community>,
	<mailto:community-request@lists.altlinux.org?subject=subscribe>
X-List-Received-Date: Wed, 12 Apr 2006 13:35:39 -0000
Archived-At: <http://lore.altlinux.org/community/443D0220.8030907@albionbpr.com/>
List-Archive: <http://lore.altlinux.org/community/>
List-Post: <mailto:mandrake-russian@linuxteam.iplabs.ru>

Vitaly Gorshkov wrote:

>АМ 2.4 +updates +backports
>
>попытался NaWT (http://netams.com/download.html) для netams поставить.
>rpm -qa|grep netams
>netams-3.3.1a-alt0.M24.1
>тут http://netams.com/download.html уже 3.3.3a
>
>дык вот пытаюсь как написано в доке к NaWT импортировать таблицу из
>файлика create.sql.
>
>а она ругается:
>ERROR 1064 at line 19: You have an error in your SQL syntax.  Check the
>manual that corresponds to your MySQL server version for the right
>syntax to use near 'character set latin1 NOT NULL default '',
>  `passport_ser` varc
>
>
>вот кусочек файла create.sql :
>CREATE TABLE `nawt_accountdata` (
>  `oid` varchar(6) character set latin1 NOT NULL default '',
>  `surname` varchar(80) character set latin1 NOT NULL default '',
>  `name` varchar(80) character set latin1 NOT NULL default '',
>  `patronymic` varchar(80) character set latin1 NOT NULL default '',
>  `street` varchar(80) character set latin1 NOT NULL default '',
>  `house` varchar(20) character set latin1 NOT NULL default '',
>  `flat` varchar(10) character set latin1 NOT NULL default '',
>  `room` varchar(10) character set latin1 NOT NULL default '',
>  `phone` varchar(40) character set latin1 NOT NULL default '',
>  `comment` text character set latin1 NOT NULL default '',
>  `passport_ser` varchar(40) character set latin1 NOT NULL default '',
>  `passport_num` varchar(40) character set latin1 NOT NULL default '',
>  PRIMARY KEY  (`oid`),
>  KEY `surname` (`surname`)
>) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
>
>Знакомый сказал что чарсеты кажися поддерживаются в MySQL 4.1
>
>у меня:
>rpm -qa| grep MySQL
>MySQL-client-4.0.24-alt0.M24.2
>libMySQL-4.0.24-alt0.M24.2
>MySQL-server-4.0.24-alt0.M24.2
>libMySQL-devel-4.0.24-alt0.M24.2
>
>вот такие дела.
>
>  
>
Именно так.  Начиная с 4.1.  В 4.0 ещё не поддерживаются.