Text how many characters

Hi just out of curiosity how man chars does the type 'text' have ? I can't seem to find it on the mysql manual. Thanks Tom

Re: Text how many characters

On Sun, Jul 22, 2001 at 05:39:24PM -0700, Tom Gao wrote: Hi just out of curiosity how man chars does the type 'text' have ? I can't seem to find it on the mysql manual. Search for storage requirements. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk:

Re: syntax problem

Sara writes: Hi I have compiled a report using Mascon only to find I can't export it to any other software I have! Great report but not much good to me as it is :-( (I'm not well versed in php yet, otherwise this might be an issue) However, I did get the sql query script and thought I

Re: Win2k

Steve writes: I am using Win2k Advanced Server and Professional. Both systems have a problem with the current version of MySQL GUI when you successfully type in the correct password, of erroring and exiting. If you type in the incorrect password, it lets you into the application and just

Problem with MySQL socket file after re-install on RH 7.1

Hello: I re-installed MySql RPM and now cannot access MySql. The details... I have RedHat 7.1 installed and am running Apache 1.3.14, MySql 3.23.26 and PHP 4.04, all from the RedHat 7.1 installation. They have been running for a month in a stable environment with any problems. I have used all 3

Technical problem: InnoDB website and email temporarily down

Hi! The host of my website www.innodb.com has technical problems again, like they had on Friday. Their help desk telephone is constantly occupied, so I assume they are doing their best to fix the problem. Also my email operator Sonera, a different company, has problems: the mail server is down.

InnoDB release in 3.23.40

Hi! MySQL/InnoDB-3.23.40 was released on Saturday. For InnoDB it is a very minor release, only a couple of rare bugs have been fixed and the my.cnf parameter name innodb_unix_file_flush_method has been shortened to innodb_flush_method Version 3.23.40 does not yet contain the support for 4

Re: Text how many characters

According to _MySQL mSQL_, by Yarger et al (O'Reilly) the TEXT datatype holds 64KB of data. Since my math skills and understanding of character storate are, well...wretched, someone should check me on this: 64KB = 64000 bytes = 64,000 characters (@ 1 character/byte), (or better

what version to download?

Hi I would like to download the MySQL server but I dont know which 1 I should download. I want to use it with MS Access and PHP so which 1 do I download? Can you supply me with a link to the correct server? Thanx Regards Neil Allen

Re: Transaction for MySQL

Hi! You can change the MySQL server program from mysqld-nt.exe or any other mysqld*.exe to mysqld-max.exe or mysqld-max-nt.exe (on NT and 2000) without changing your MyISAM tables in any way. The MyISAM part in these versions is identical. To use InnoDB tables you have to add startup

Re: Text how many characters

So sprach »Nelson Goforth« am 2001-07-22 um 09:00:13 -0600 : According to _MySQL mSQL_, by Yarger et al (O'Reilly) the TEXT datatype holds 64KB of data. Since my math skills and understanding of character storate are, well...wretched, someone should check me on this: 64KB = 64000

Problems in compiling mysql 3.23.39a on win2000

Hello all, i try to compile mysql 3.23.39a with VC 6.0 on win2000 but i always got the same error like this: unresolved external symbol does anybody know what to do? Regards Dimi __ Fast alle Fluege koennen

Re: syntax problem

Hi Thanks very much for your informative post Sinsia. I rather thought that this was the whole purpose of this mailing list? If I had all the answers and indeed the skills, I would not have posted to the list in the first place. I have been trying to find information in the web, and from

Re: syntax problem

I rather thought that this was the whole purpose of this mailing list? You are right both in your inquiry and in your reply to Sinisa. It is not his usual way, though, I was astonished myself. I think most is ok. Try select handicap_results.date, handicap_results.victor,

Re: what version to download?

Hi I would like to download the MySQL server but I dont know which 1 I should download. I want to use it with MS Access and PHP so which 1 do I download? Take the latest version from the download area in http://mysql.com -- Herzlich Werner Stuerenburg

Problem installing mysql++1.7.9

Running ./configure fails check for MySQL include directory. The library directory is found and the include directory is there when I list it. What is it looking for? Eldon Ziegler ProAtion Systems [EMAIL PROTECTED] http://www.proation.com

Re: syntax problem

Hi And thanks for your time I have been building up basic queries exactly as you suggested today. I can get the information I want without a join but it is not easy to get the informaton displayed as nicely. Mascon did give me an error about alias's at one time, but to be honest I didn't

Test suite fail on merge ...

Hi all: I compiled mysql 3.23.40 and I got the followin result after make test. All tests passed except merge. I am not sure what to make of the dump ... I am hoping that someone may be able to tell me if it is critical and if there's a solution. I have not make install yet because I am not

[mysql.server stop fails under OpenBSD 2.9]

Description: mysql.server stop fails to stop the server even though mysql.server start was used to start it. The INSTALL-SOURCE text file recommends using the script support-files/mysql.server to start mySQL at boot-time. The startup works nice, but

Removal of MySQL

Is there a simple command one can give in Linux that will remove all trace of Mysql except the databases so that I can install from fresh? Michael Johnson Director Humphrey Consulting Limited BPEnet 13 Austin Friars London EC2N 2JX Tel +44 (0)1323 438975 Fax +44(0)1323 738355 Email [EMAIL

Re: Perl Script: MySQL Slow Query Log Parser

Great. Thanks. Tim. - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Tim Bunce [EMAIL PROTECTED] Cc: Nathanial Hendler [EMAIL PROTECTED]; Mysql [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, July 20, 2001 12:05 AM Subject: Re: Perl Script: MySQL Slow Query Log

Re: Removal of MySQL

michael johnson [EMAIL PROTECTED] writes: Is there a simple command one can give in Linux that will remove all trace of Mysql except the databases so that I can install from fresh? That is very dependent on how you installed it. If you used rpm, you can just do rpm -e mysql mysql-server

MYODBC DSN creation

Have successfully installed MYODBC, driver shows up in Windows Control Panel, and when I try to add a new User DSN the setup screen appears. I add the info as outlined in the Mysql manual for 3.23.39 and everything appears ok, but I can't find the DSN when I want to connect to Mysql. Did a file

Re: MYODBC DSN creation

- Original Message - From: David Rickerl [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, July 22, 2001 2:57 PM Subject: MYODBC DSN creation Have successfully installed MYODBC, driver shows up in Windows Control Panel, I assume that you mean in the Data Sources window/utility.

Re: MySQL Timing out

Its using PHP, so I haven't tried it without apache. I actually tried a different version of Apache, running it as an NT service on 98 and that seems to work better. Still doesn't explain why the other version caused a problem for me though - Original Message - From: Jeremy Zawodny [EMAIL

Re: Questions about extremely large database support

On Sat, 21 Jul 2001, Sergei Golubchik wrote: Date: Sat, 21 Jul 2001 10:36:22 +0200 From: Sergei Golubchik [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Tom Wheeler [EMAIL PROTECTED] Subject: Re: Questions about extremely large database support Hi! On Jul 20, Jeremy Zawodny wrote: On

Problem in starting mysqld

Hi, Sorry I still have a problem in starting mysqld the first time. Even after I have runned the mysql_install_db script, I run safe_mysqld script, but it still fail to start the mysqld. The following error message is found in the log: 010723 10:17:14 mysqld started 010723 10:17:14

how do I find out where the files are stored ?

I installed MySQL using the binay (RPM) version on RedHat Linus 7.0 How can I find out where the various MySQL files are installed to? Thanks YekSoon __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger