Invalid ENUM values after upgrading from 4.0 to 4.1

Hi, I'm facing a problem with the new 4.1 branch. I've built MySQL from sources with default-language=hebrew and extra-languages=utf. I've also used default-collation=hebrew_general_ci. After installing, this is what I get for few of the variables: mysql show variables like '%char%';

RE: Unknown auto ROLLBACK

What is that option? Never saw it before. If this is the case indeed, how do you change its value? Thanks again. Noor -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 4:52 PM To: Noor Dawod Cc: MySQL List Subject: Re: Unknown auto

Unknown auto ROLLBACK

Hi all, I found out today that MySQL is adding a 'ROLLBACK' command to each session connecting to it, without explicitly ordering this. This is new since we never had this behavior before. Why is this happening, and how can I revert to the old beahvior (each command sent is carried out and

MySQL 4.0.3 crashing on FreeBSD 4.6-STABLE

Hi all, I've been trying to install version 4.0.3 of the new MySQL branch 4.0 but got a problem that I cannot seem to solve. Installing MySQL 4.0.3, both in binary and source compilation, yields always the following error when I try to visit a website written in PHP: 020912 09:46:19 mysqld

Unix_TimeStamp()

Hi, Does the function Unix_TimeStamp() work in MySQL under Windows NT? It doesn't seem to work here in simple queries, such as this query: Select Unix_TimeStamp(); Thanks Noor - Before posting, please check:

Exporting data from MySQL to Oracle

Hello, I'm having a problem exporting MySQL BLOB's to Oracle, especially those records that has "Carriage Return" or "Line Feed" characters in them. Has anyone done this before, and how did they do it? I need an immediate help in this subject. I'd appreciate you help very much. Thanks Noor

TEXT's are giving us headaches!

Hello, We operate a forums website and use Phorum web application (PHP/MySQL backend), more info: http://www.phorum.org After operating for two years now, we are facing a serious problem. Giving the fact that the forums are full of content, ONE (1) search operation on a single forum is draining

RE: TEXT's are giving us headaches!

Terry [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 6:07 PM To: Noor Dawod Cc: [EMAIL PROTECTED] Subject: Re: TEXT's are giving us headaches! A mistake I made for a long time with MATCH AGAINST is to not include it in the WHERE clause eg I did SELECT ID,MATCH Q,A AGAINST

RE: Exporting data from MySQL to Oracle

I couldn't find such product on Oracle's website. Noor -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 5:51 PM To: Noor Dawod; MySQL List Subject: RE: Exporting data from MySQL to Oracle Didn't Oracle just release a MySQL to Oracle

RE: Unexplained high-loads on FreeBSD

Hi Sinisa Is the FreeBSD problem previously submitted by me known to you? Noor -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Monday, January 22, 2001 3:32 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Unexplained

RE: Unexplained high-loads on FreeBSD

Hello Jan and all, I have issued a "show processlist" all the time during the time that mysqld is at high loads, but I didn't notice slow queries of some kind. Furthermore, I personally go over all queries and tables produced by our developers to insure proper syntax and indexing, so I am pretty