Problem with default-collation

2005-03-17 Thread Dana Sharvit - M
Hi, I am using mysql Ver 14.7 Distrib 4.1.8, for pc-linux (i686) When running a certain query I get the following error: DBD::mysql: t execute failed: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'find_in_set' I do not understand why I have

problem with LOAD DATA

2005-02-22 Thread Dana Sharvit - M
Hello, I am using mysql Ver 14.6 Distrib 4.1.5-gamma, for sun-solaris2.8 (sparc) I am having a problem with using the following query from a perl program: LOAD DATA LOCAL INFILE ? REPLACE INTO TABLE $table The error I get is: DBD::mysql::st execute failed: The used command is not allowed with

out f memory error

2003-06-05 Thread Dana Sharvit - M
I have a program that runs a loop,in every loop I execute a query. the query itself is very efficient, the result of the query is 4 rows at most but... after a while I get the following error: Out of memory! Bus error (core dumped) how can I increase the memory that is used for the query? Thanks