Problem with default-collation

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 a

problem with LOAD DATA

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 t

out f memory error

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

inserting records into database with utf8 char-set

Hello, I am attempting to insert a string in utf-8 to a text field using DBI but mysql does preserve the original char_et but rather changes it, does any one have any idea why? I am working with Mysql 3.23.36 DBI-1.30 Thanks Dana

MYSQL error 127

Hi, when trying to perform any queries on a specific table I get the following error: "Got error 127 from table handle" I could not find the meaning of this error in the mysql documentation, any ideas? any way I tried repairing the table using myisamchk with no success, any other ideas? Thanks D

error when running myql on Linux 7.1

Hello, As you probably know mysql comes installed in Linux 7.1 as default. I installed my own mysql server in a different location in the file system, In safe_mysqld I indicated the path in which I want the mysql.sock to be created in but when I start my mysql server I get an error message: Can't

UTF-8

If I understand correctly I can load data in UTF-8 to a MySql database that was compiled with character set (Latin-1). In all of the documentation that I looked at there is an indication that due to the lack of direct Unicode support in MySQL the use of the data which is stored in UTF-8 will be p

UNICODE

Hello, is there any UNICODE support for Mysql? Dana - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL

error when compiling mysql version mysql-3.23.8-alpha

Hello, When compiling mysql-3.23.8-alpha on Solaris 2.8 I get the following error: mi_create.c: In function `mi_create': mi_create.c:437: `MY_CHARSET_lAtin1' undeclared (first use in this function) mi_create.c:437: (Each undeclared identifier is reported only once mi_create.c:437: for each funct

installing mysql

Hello, I am trying to install mysql(mysql-3.23.8-alpha) on Solaris2.8 with a prefix of the installation directory. the configure is ok but when I try to run make I get the following errors: sh: ar: not found *** Error code 1 make: Fatal error: Command failed for target `libreadline.a' Current wor

accessing mysql via a c program

Hello, were can I find documentation regarding accessing mysql database via a c program?maybe some examples of a simple c program. Thanks Dana - Before posting, please check: http://www.mysql.com/manual.php (the manual) h