Protocol mismatch, Server Version = 9 Client Version =

Hello I have a C app that uses libmysql.dll provided with MySQL 4.1.0-max-nt distribution. I am trying to connect to a remote server running MySQL 3.23.47 and I get the error - Error No. 2007 Protocol mismatch, Server Version = 9 Client Version = 10 whenever I try to connect using mysql_real_co

Error No. 2007 Protocol mismatch, Server Version = 9 Client Version = 10

Hello I have a C app that uses libmysql.dll provided with MySQL 4.1.0-max-nt distribution. I am trying to connect to a remote server running MySQL 3.23.47 and I get the error - Error No. 2007 Protocol mismatch, Server Version = 9 Client Version = 10 whenever I try to connect using mysql_real_co

Re: Fulltext Index and Unicode (MySQL 4.1)

Hi! On Sep 06, Andreas Schwarz wrote: > Egor Egorov wrote: > > Andreas Schwarz <[EMAIL PROTECTED]> wrote: > >> > >> is it possible to use Fulltext indexes on unicode (UTF-8 or UCS-2) > >> fields in 4.1? > >> > > > > Nope. Fulltext search doesn't work with multi-byte character sets. > > Will th

Re: Help with the "IN" operator

At 11:25 -0400 9/6/03, Roger Davis wrote: I am having a bit of trouble with the "IN" operator. I am thinking that it just may be my misunderstanding. Situation. I have a table (ZipCounty) that I want to pull vendors from based on zipcode. So I have a Vendor like field declared as TEXT. T

Re: Help with the "IN" operator

You are misunderstanding the 'IN' operator Try and think of it this way SELECT value from table where field in (1,2,3) is the same as SELECT value from table where field = 1 or field = 2 or field = 3 So in you case SELECT Count(ID) FROM ZipCounty WHERE '528' IN (VendorLink); is SELECT Count(ID)

Re: Fulltext Index and Unicode (MySQL 4.1)

At 11:25 + 9/6/03, Andreas Schwarz wrote: Egor Egorov wrote: Andreas Schwarz <[EMAIL PROTECTED]> wrote: is it possible to use Fulltext indexes on unicode (UTF-8 or UCS-2) fields in 4.1? Nope. Fulltext search doesn't work with multi-byte character sets. That's correct. It's documented at:

Re: Regular Expression Reference

At 11:08 -0400 9/6/03, Jeff Brewer wrote: I'm sure this is sitting inches from my nose but I just can't see it. In Appendix G of the manual it states: "This is a simplistic reference that skips the details. To get more exact information, see Henry Spencer's regex(7) manual page that is included

Help with the "IN" operator

I am having a bit of trouble with the "IN" operator. I am thinking that it just may be my misunderstanding. Situation. I have a table (ZipCounty) that I want to pull vendors from based on zipcode. So I have a Vendor like field declared as TEXT. To keep the table up to date, I issuse upd

Regular Expression Reference

I'm sure this is sitting inches from my nose but I just can't see it. In Appendix G of the manual it states: "This is a simplistic reference that skips the details. To get more exact information, see Henry Spencer's regex(7) manual page that is included in the source distribution." I can't seem

MySQL on Windows 2000

Hi, We have installed PHP/MySQL on a Windows 2000 server. PHP & MySQL are working fine on the server. We also require to connect ASP to MySQL database. How can we do that? Currently the MySQL/ODBC driver is not available on Windows 2000 server. How can we add that and proceed with ASP/MySQL?

Sobig.F on this list

I got a bounced email with an attachment entitled macex.mex.scr, about 72.3 KB, which if IIRC is probably the Sobig.F virus. It appears to have been sent to people on this list (even though the list wasn't in the "to:" line) because the body of the email discussed MySQL. Since Sobig.F forges the

Re: Fulltext Index and Unicode (MySQL 4.1)

Egor Egorov wrote: > Andreas Schwarz <[EMAIL PROTECTED]> wrote: >> >> is it possible to use Fulltext indexes on unicode (UTF-8 or UCS-2) >> fields in 4.1? >> > > Nope. Fulltext search doesn't work with multi-byte character sets. Will this be fixed in future versions? Otherwise I would have to d

group_concat()

I finally installed 4.1 alpha so I could test the group_concat function but need some help... could anyone give me a clue how I can order the results of group_concat() according to the lft field ? (just adding it per se wipes out the results) I have tried many many variations and have not hit upon

Re: Query hung up in "Copying to tmp table"

Kevin, Forgot to mention that I think you're not seeing any temporary files because they're hidden. From http://www.mysql.com/doc/en/Temporary_files.html "MySQL creates all temporary files as hidden files. This ensures that the temporary files will be removed if mysqld is terminated. The disadvan