Custom agregate functions

[Dainis Polis]

Hi MySQL  fans!

Is there way to  create  subj ?


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Where is the utf8_general_ci collation in sources?

[Dainis Polis]

Hi  All!
Where to find  subj.?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

collate utf8_bin vs utf8_general_ci

[Dainis Polis]

Hi  again!
This query  is ok:
create table TEST (id int,saturs char(255) charset utf8  )
alter table TEST add fulltext (saturs);
drop table TEST;
,
create table TEST (id int,saturs char(255) charset utf8 collate utf8_bin )
alter table TEST add fulltext (saturs)
Can't create table './likumi/#sql-240_4E.frm' (errno: 140)
but  while  this get error ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Boolean mode, Fulltext,utf8

[Dainis Polis]

Hi All!
Does works fulltext index  on  utf8  columns  on boolean  mode  
correctly  on
MySql  4.1.2 ?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

fulltext in boolean mode with utf8

[Dainis Polis]

Hi All!
May be anyone can help in this situation:
Version: 4.1.2-alpha-nightly-20040523-log
OS : Linux
Show create table TEST:
CREATE TABLE `TEST` (
`ID` int(10) unsigned NOT NULL auto_increment,
`saturs` char(255) default NULL,
PRIMARY KEY (`ID`),
FULLTEXT KEY `sat` (`saturs`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
insert into TEST (ID,saturs) values (1, _cp1257 'pa-r par par')
insert into TEST (ID,saturs) values (2, _cp1257 'par par par')
select * from TEST:
ID saturs
1 pÄ?r par par
2 par par par
select * from TEST where match(saturs) against('par' in boolean mode) :
no rows
_
So while no rows in last search?






--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]