results with utf8 characters

Hi, sorry, I must ask again, because there was no answer to this problem until now. I've installed mysql 4.1.3 as rpm package. If SELECT results columns with unicode characters (multibyte characters like german umlauts), the shown frame in my client is defective: mysql select * from uml;

mysqldump -Q

Hi, mysqldump has an flag '-Q' which quotes all table and column names. But what about the database names? They will not be quoted (in the CREATE and USE statements)! During transformation of databases from a 3.23 server to 4.1 I have some databases with '-' inside the name (obviously this was

MySQL 4.1 and UTF8

Hi, I've followed the discussion about UTF8 and MySQL-4.0 in the last days ... But now I need some additional explanation. With version 4.1, support of different character sets is included. I see it in my server, that 'show variables like %character%' gives me some interesting information:

Re: MySQL and SSL

Egor Egorov schrieb: Michael Dykman [EMAIL PROTECTED] wrote: could someone please tell me which versions of mysql support SSL connections for both clients and replication slaves? The -Max build. i'd installed MySQL-Max-4.0.20-0.i386.rpm from download area of www.mysql.org, but the server doesn't

/etc/my.cnf

Hi, I've installed MySQL-4.0.20 on Linux Fedora 1 as rpm from the download area of www.mysql.com. The server starts and runs. But I cannot configure some options in /etc/my.cnf: - with 'err-log' the server doesn't start - 'pid-file' and 'log-bin' will be ignored - some other I must try in the

Re: /etc/my.cnf

But I cannot configure some options in /etc/my.cnf: - with 'err-log' the server doesn't start - 'pid-file' and 'log-bin' will be ignored sorry, it was a mistake of me: I'd used an option group [safe_mysqld] instead of [mysqld_safe] perhaps the starting procedure should inform me that there is

grants for non-root

I try to set *all* privileges to a user, which should not called 'root' but should have its privileges (I'm connected as root): mysql grant all on *.* to 'mysqladmin'@'localhost'; Query OK, 0 rows affected (0.00 sec) But now I get mysql show grants for 'mysqladmin'@'localhost'; ERROR 1141: There

mysqldump overflow?

Hi, I want to save a database with 'mysqldump' and get the following error: mysqldump: Got error: 1105: File '/var/lib/mysql/mydb/J99.MYD' not found (Errcode: 24) when using LOCK TABLES But the file *does* exist: ls -l /var/lib/mysql/mydb/J99.MYD -rw-r-1 mysqlmysql 224 Feb

time_to_sec problem

Hi, after updating my mysql server to version 3.23.22 on a linux box, I've found the following problem: select time_to_sec('03:53:00'); results with the correct value 13980. But if I use a table of such time dates (in the simplest case: "create table xy (st time); insert into xy values