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

-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

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

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

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 answer

[PHP] Re: novice: char to varchar

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), PRIMARY