Re[4]: client dependent timezone

2002-03-29 Thread Maxim Vysotskiy
Hello DL, I know about the possibility of having different TimeZones for different servers (the mysql manual states that it's possible through setting TZ environment variable). But my situation is that I have a shared webhosting in GMT+1 (and mysql TZ is GMT+1), but application needs to have a

client dependent timezone

2002-03-28 Thread Maxim Vysotskiy
Hello mysql, So nobody here (even at MySQL AB) knows how to set a timezone for a MySQL client ? Not for whole server but per client? (or maybe for database???) I already posted this question here few days ago - and didn't get any reply. Please! Somebody help! -- Best regards, Maxim

Re[2]: client dependent timezone

2002-03-28 Thread Maxim Vysotskiy
it to your local timezone so it GRJ does not return values in GMT. GRJ If you want clients to have different timezones, perhaps you should write GRJ that capabilty into your front-end application. GRJ Gerald Jensen GRJ - Original Message - GRJ From: Maxim Vysotskiy [EMAIL PROTECTED] GRJ

Re[2]: client dependent timezone

2002-03-28 Thread Maxim Vysotskiy
it to your local timezone so it GRJ does not return values in GMT. GRJ If you want clients to have different timezones, perhaps you should write GRJ that capabilty into your front-end application. GRJ Gerald Jensen GRJ - Original Message - GRJ From: Maxim Vysotskiy [EMAIL PROTECTED] GRJ

MySQL client timezone

2002-03-26 Thread Maxim Vysotskiy
Hello 'mysql, Does anybody know is this possible to set some particular timezone for the session? ie: server is in GMT, but application needs time selected in GMT+3 Is there any universal way ? Thanx for any hint in advance -- Best regards, Maxim mailto:[EMAIL

Re: PHP, BLOB file, MySql and my web site

2002-03-26 Thread Maxim Vysotskiy
Hello Tokunboh, I'm not saving any binary data in database, only saves relative (to webserver root) image paths there, and then just put them to img src= tag. Wednesday, March 27, 2002, 3:05:35 AM, you wrote: OT Hi All, OT Can anyone guide me on how to list the content of mysql table or

temporary tables select

2002-03-26 Thread Maxim Vysotskiy
Hello mysql, I have strange problem: I create a temporary table (let's say temp_table) with one bigint(20) field. And then, when I try select * from temp_table in same session - mySQL says that this table doesnot exist.. But I cannot create one more in this session - mySQL says that this table