Working with the text datatype in MySQL

2003-07-17 Thread Lekeas GK
Hi All, I am managing a small database and some of the tables need to be strings of an average length of about 2,000 characters. I decided to use the text datatype to store this information knowing that the upper limit is about 65,000 characters. However, the system crashes when the user tries t

Working with the text datatype in Mysql

2003-07-18 Thread Lekeas GK
Hi All, I am managing a small database where a few fields are defined as being of type text. In my understanding, this would allow the user to enter up to about 65,000 characters in the text field. However, if the user types about 2,000 characters, then nothing is entered in the database. I have

Re: Working with the text datatype in Mysql

2003-07-18 Thread Lekeas GK
about what might be causing the problem... Thanks, George "I think there is a world market for maybe five computers." Thomas Watson, Chairman of IBM, 1943. - Original Message - From: "gerald_clark" <[EMAIL PROTECTED]> To: "Lekeas GK" <[EMAIL PROTECTED]

Re: Working with the text datatype in Mysql

2003-07-18 Thread Lekeas GK
They type the information from a web page. George "I think there is a world market for maybe five computers." Thomas Watson, Chairman of IBM, 1943. - Original Message - From: "Ed Leafe" <[EMAIL PROTECTED]> To: "Lekeas GK" <[EMAIL PROTECTED

Re: Working with the text datatype in Mysql

2003-07-18 Thread Lekeas GK
there is a world market for maybe five computers." Thomas Watson, Chairman of IBM, 1943. - Original Message - From: "gerald_clark" <[EMAIL PROTECTED]> To: "Lekeas GK" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, July 18, 2003 3:00 P

Re: Working with the text datatype in Mysql

2003-07-18 Thread Lekeas GK
t; <[EMAIL PROTECTED]> To: "Lekeas GK" <[EMAIL PROTECTED]> Sent: Friday, July 18, 2003 4:31 PM Subject: RE: Working with the text datatype in Mysql | George, | You keep leaving out the vital bits. What are your sers using to enter | this data? We know it's a web page

Re: Working with the text datatype in Mysql

2003-07-18 Thread Lekeas GK
om: "Rob A. Brahier" <[EMAIL PROTECTED]> To: "Lekeas GK" <[EMAIL PROTECTED]> Sent: Friday, July 18, 2003 5:01 PM Subject: RE: Working with the text datatype in Mysql | hmm, add this after your mysql_query() line in the script | | echo mysql_error(); | | Does that re

Re: Working with the text datatype in Mysql

2003-07-18 Thread Lekeas GK
there from | when you last ran the script--it may be crashing. | | -Rob | | -Original Message- | From: Lekeas GK [mailto:[EMAIL PROTECTED] | Sent: Friday, July 18, 2003 12:29 PM | To: Rob A. Brahier | Cc: [EMAIL PROTECTED] | Subject: Re: Working with the text datatype in Mysql | | |

Re: RE: MySQL Locales

2002-05-14 Thread Lekeas GK
> > Yes, > > > > Just add default-character-set=greek line in your > > /etc/my.cnf (or whereever > > the global server specificationa are read) . > > > > Gurhan Thanks a lot for your prompt reply...Could you please advice me as well how am I going to insert them given that the default language f

Re: RE: MySQL Locales

2002-05-14 Thread Lekeas GK
That's a good idea, but if you have something like 2000 entries it can be a lifetime typing one by one...that's why I would like to do it through a script...Does phpmyadmin supports scripts? George - Original Message - From: "Gurhan Ozen" <[EMAIL PROTECTED]&g

Handling 'one-off' customers wirh MySQL

2002-06-11 Thread Lekeas GK
Hi All, I am developing an application for an online CD-shop using PHP and MySQL and I need to be able to handle 'one-off' customers. This category includes customers who do not want their details to be retained in the shop's database once the order is shipped to them. I am not quite sure whethe

Handling 'one-off' customers with MySQL

2002-06-11 Thread Lekeas GK
Hi All, I am developing an application for an online CD-shop using PHP and MySQL and I need to be able to handle 'one-off' customers. This category includes customers who do not want their details to be retained in the shop's database once the order is shipped to them. I am not quite sure wheth

Tee otpion

2001-03-02 Thread Lekeas GK
I would like to know how you can stop logging without exiting the mysql session. For example in SQL you have the spool command and when you want to stop logging you just type spool off. Is there anything similar in mysql? I look forward to hearing from you soon. Thanks in advance. George