utf8_polish_ci

2004-07-01 Thread Marek Lewczuk
Hello, I'm using MySQL 4.1.2 and it should be available utf8_polish_ci collation. But, it seems that it is not. # Query: # SHOW COLLATION LIKE 'utf%' # 'Collation''Charset','Id','Default','Compiled','Sortlen' 'utf8_general_ci','utf8','33','Yes','Yes','1' 'utf8_bin','utf8','83','','Yes','1' The

When 4.1.2 release

2004-05-24 Thread Marek Lewczuk
In the documentation there is a note that 4.1.2 will be released soon. I need some features which are available only in this version... Any estimated date when it will be ? Sorry for asking about the same thing... ML -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

UTF-8 problem

2004-05-24 Thread Marek Lewczuk
Hello, I've just installed 4.1.1 to see how UTF-8 is working. In my.ini I have set default-character-set=utf8 - so all input/output data should be send in utf-8 charset. System variables (after start) are set as they should: character_set_serverutf8 character_set_system

when 4.1.2 release

2004-04-17 Thread Marek Lewczuk
Hello, when do you plan to release 4.1.2 version ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

When release of 4.1.1

2003-10-23 Thread Marek Lewczuk
Can you tell us, when you plan to release 4.1.1 version ? A few weeks ago, Heikki guess was: ...before Nov 15th, 2003. And how it looks now ? Best regards, ML -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

RE: Referential integrity, FULLTEXT and table types

2003-07-28 Thread Marek Lewczuk
I need to have a table that supports FULLTEXT searches. This implies that this table should be a MyISAM table. However, I also require that this table act as a parent for child tables in order to support referential integrity. If I create the child tables as INNODB tables, will

LEFT JOIN limitations ??

2003-07-25 Thread Marek Lewczuk
Hello, I have a strange problem, maybe some of you will be able to explain me something. I use LEFT JOIN as a substitute for subselects. It's true that many subselects can be rewriten using LEFT JOIN. I have made a query which use LEFT JOIN statement and... when there are many LEFT JOIN's (over 3)

MySQL tables performance question

2003-07-23 Thread Marek Lewczuk
columns ?? Marek Lewczuk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Full-Text for InnoDB Unicode

2003-07-23 Thread Marek Lewczuk
As far I remember full-text doesn't work with utf-8. Anybody knows the estimated time when it will be supported ?? I next few months 4.1 version will be ready to use (I hope so...) and I wish to use utf-8 charsets, but very important issue is full-text search. I'm also curious with InnoDB support

Set variable ft_min_word_len

2003-07-22 Thread Marek Lewczuk
On our Linux server we get this error: 030722 08:09:55 mysqld started /usr/local/mysql/bin/mysqld: ERROR: unknown variable 'ft_min_word_len = 2' 030722 08:09:55 mysqld ended [...] It's strange becouse I can set this variable through my.ini on my Windows. Anyone can help me solve this problem ?

RE: Set variable ft_min_word_len

2003-07-22 Thread Marek Lewczuk
At 8:20 +0100 7/22/03, Marek Lewczuk wrote: On our Linux server we get this error: 030722 08:09:55 mysqld started /usr/local/mysql/bin/mysqld: ERROR: unknown variable 'ft_min_word_len = 2' 030722 08:09:55 mysqld ended [...] It's strange becouse I can set this variable through my.ini

RE: Set variable ft_min_word_len

2003-07-22 Thread Marek Lewczuk
the correct syntax is WITHOUT quotes and WITHOUT spaces. --ft_min_word_len=2 or -O ft_min_word_len=2 -- but -O is obsolete but not -O 'ft_min_word_len = 2' But we want to set this variable in my.cnf, so the syntax shouldn't be like this: set-variable =

Building from the develepment tree (windows)

2003-07-16 Thread Marek Lewczuk
I'm trying to build mysql from the development sources of mysql 4.1., retreived using bitkeeper under win2k using cygwin. I have made bk -r edit, and now I'm having a problem running aclocal: aclocal: configure.in: 450: macro `AM_PROG_AS' not found in library When I make automake --version and

MySQL vs. PostgreSQL -- speed test

2003-07-14 Thread Marek Lewczuk
Hello group, For everyone who thinks about moving from MySQL to PostgreSQL I have a realy bad news - It's not worth. Why, You may ask... A few days ago I have installed and tested PostgreSQL, becouse I realy need UTF-8 support and subselects. I thought that PostgreSQL will be as good as MySQL but

RE: MySQL vs. PostgreSQL -- speed test

2003-07-14 Thread Marek Lewczuk
If maximum speed is critical. It's easy to lose sight of the fact that speed is not the only criterion in choosing a DBMS. Features, stability, security, and so on can be just as important or more so. No single DBMS is going to win all the prizes; the trick is to find the one with

RE: MySQL vs. PostgreSQL -- speed test

2003-07-14 Thread Marek Lewczuk
which PostgreSQL version have you testet? If you want compare MySQL and PostgreSQL, than you have to use InnoDB tables. Tests with MyISAM make no sense. Out J2EE Application is working woth PostgreSQL 7.3.3 and MySQL 4.0.13 with InnoDB tables (we need transactions and referencial

RE: MySQL vs. PostgreSQL -- speed test

2003-07-14 Thread Marek Lewczuk
I agree with your opinion in 100%, but in my case I need DBMS with features like subselectes/utf-8/stored procedures but the speed is also very important issue. You might have to spend money! You are saying that there is DBMS with all this features and it is as fast as MySQL ? --

Utf-8 in 4.1

2003-05-28 Thread Marek Lewczuk
Hello, 4.1 version can use UTF-8 encoding, but as far I remember there is something wrong with this feature. Can you tell us when 4.1.1 version will be released and is it will be fixed. Best regards, Marek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

InnoDB: no full text search alternative solution ??

2003-03-21 Thread Marek Lewczuk
Hello, As you all know InnoDB doesn't support full text search. My application is a huge news system with about 100 new news per day. All of my tables are in InnoDB becouse of foreign keys. Today I find out that the main feature of news system - searching - is not available. It's quite big

Problem with unique index on InnoDB

2003-02-25 Thread Marek Lewczuk
); MySQL should send an error before second query, that there is the record which is the same as the inserting one... But NO, you can add as many as you want... Is this a bug or I'm doing something wrong. I would be appreciated for help!! Marek Lewczuk POLAND

RE: Problem with unique index on InnoDB

2003-02-25 Thread Marek Lewczuk
records... In article [EMAIL PROTECTED], Marek Lewczuk [EMAIL PROTECTED] writes: Hello group, My table look like this: CREATE TABLE `mda_models` ( `model_id` int(10) NOT NULL auto_increment, `make_id` int(10) NOT NULL default '0', `model_name` varchar(100) NOT NULL default