noob : advice on design?

2005-07-06 Thread Monty Harris
Dear Group, I have just completed the Sams MySQL in 24 hours and feel like I now have a reasonable understanding of creatinf queries, etc. However, the one area that seemed sadly lacking was that of database design. I recently purchased a book named "Database design for mere mortals", which seems

Re: time zones

2005-04-28 Thread Monty Harris
> How does one cope with time zones? For example, if I want to timestamp a > record it will timestanp using the local time of my server. I thought that, > e.g if my server was in New York and my customer_location was the UK, I can > just add 5 hours to the time and it would be correct. > While th

time zones

2005-04-27 Thread Monty Harris
How does one cope with time zones? For example, if I want to timestamp a record it will timestanp using the local time of my server. I thought that, e.g if my server was in New York and my customer_location was the UK, I can just add 5 hours to the time and it would be correct. While that might

Returned mail: Data format error

2004-11-16 Thread monty
The original message was received at Tue, 16 Nov 2004 09:14:51 +0100 from mysql.com [173.126.215.252] - The following addresses had permanent fatal errors - <[EMAIL PROTECTED]> - Transcript of session follows - ... while talking to 92.153.98.85: >>> RCPT To:<[EMAIL PROTECTED]> <<

Re: Storing foreign characters in DB

2004-09-06 Thread Monty
o support foreign characters used in French, German and Spanish mostly. So, I presume that Latin1 is all I need for now. Also, I'm storing this data all in the same database. Monty -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]