[Comm] MySQL 4.1

ALT Linux Community general discussions
 help / color / mirror / Atom feed

* [Comm] MySQL 4.1
@ 2006-04-12 12:23 Vitaly Gorshkov
  2006-04-12 13:35 ` Dmitry Zorin
  0 siblings, 1 reply; 3+ messages in thread
From: Vitaly Gorshkov @ 2006-04-12 12:23 UTC (permalink / raw)
  To: Community

АМ 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

вот такие дела.






^ permalink raw reply	[flat|nested] 3+ messages in thread

* Re: [Comm] MySQL 4.1
  2006-04-12 12:23 [Comm] MySQL 4.1 Vitaly Gorshkov
@ 2006-04-12 13:35 ` Dmitry Zorin
  2006-04-13  4:47   ` Vitaly Gorshkov
  0 siblings, 1 reply; 3+ messages in thread
From: Dmitry Zorin @ 2006-04-12 13:35 UTC (permalink / raw)
  To: ALT Linux Community

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 ещё не поддерживаются.



^ permalink raw reply	[flat|nested] 3+ messages in thread

* Re: [Comm] MySQL 4.1
  2006-04-12 13:35 ` Dmitry Zorin
@ 2006-04-13  4:47   ` Vitaly Gorshkov
  0 siblings, 0 replies; 3+ messages in thread
From: Vitaly Gorshkov @ 2006-04-13  4:47 UTC (permalink / raw)
  To: ALT Linux Community

>
> Именно так.  Начиная с 4.1.  В 4.0 ещё не поддерживаются.
>
> _______________________________________________
>   

а будет ли для АМ 2.4 счастие?


^ permalink raw reply	[flat|nested] 3+ messages in thread

end of thread, other threads:[~2006-04-13  4:47 UTC | newest]

Thread overview: 3+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2006-04-12 12:23 [Comm] MySQL 4.1 Vitaly Gorshkov
2006-04-12 13:35 ` Dmitry Zorin
2006-04-13  4:47   ` Vitaly Gorshkov

ALT Linux Community general discussions

This inbox may be cloned and mirrored by anyone:

	git clone --mirror http://lore.altlinux.org/community/0 community/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 community community/ http://lore.altlinux.org/community \
		mandrake-russian@linuxteam.iplabs.ru community@lists.altlinux.org community@lists.altlinux.ru community@lists.altlinux.com
	public-inbox-index community

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


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