Re: [PHP] Re: novice: char to varchar

2005-05-19 Thread tony yau
Hi Kim, I've found the same article that Philip Hallstrom <[EMAIL PROTECTED]> had posted Tony "Kim Madsen" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > -Original Message- > From: tony yau [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 18, 2005 9:03 PM > found the

Re: [PHP] Re: novice: char to varchar

2005-05-19 Thread Satyam
My guess is that the solution is that MySql, though it supports the syntax for standard SQL and thus takes char and varchar, it actually doesn't have a specific storage type for each, all chars are stored in varchar fields, just as all boolean or bit fields are stored in integer fields. Though

RE: [PHP] Re: novice: char to varchar

2005-05-19 Thread Kim Madsen
> -Original Message- > From: tony yau [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 18, 2005 9:03 PM > found the answer sorry about this But You don“t wanna share the solution with the rest of the class? -- Med venlig hilsen / best regards ComX Networks A/S Kim Madsen Systemudvikler/S

[PHP] Re: novice: char to varchar

2005-05-18 Thread tony yau
found the answer sorry about this "Tony Yau" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi all, > > I try to do the following: > > CREATE TABLE IF NOT EXISTS Invoice( > PKey INTEGER, > Received DATETIME, > Cost DECIMAL(10,2), > FileName VARCHAR(50), > RefNum CHAR(10),