BBEdit tip (was: Differences between MySQL 4 and 5 for scripts)

2006-06-15 Thread Chris Sansom
At 23:00 +0100 14/6/06, Graham Reeds wrote: 1) You may have a bogus hidden character in your SQL file. If you look at it with a text editor (BBEdit, TextWrangler, etc), with the "show invivisbles" feature on, do you see unusual stuff? Sounds strange but I've seen stranger. Took a brief look

Re: Differences between MySQL 4 and 5 for scripts

2006-06-14 Thread Jim Winstead
On Wed, Jun 14, 2006 at 11:00:36PM +0100, Graham Reeds wrote: > Dan Buettner wrote: > >Graham, I seem to recall those single quote marks working without a > >problem on various platforms and versions of MySQL. Of course they are > > generally just a nicety and only required if you are using rese

Re: Differences between MySQL 4 and 5 for scripts

2006-06-14 Thread Graham Reeds
Dan Buettner wrote: Graham, I seem to recall those single quote marks working without a problem on various platforms and versions of MySQL. Of course they are generally just a nicety and only required if you are using reserved words as table/column/key names, so you could just remove them ent

Re: Differences between MySQL 4 and 5 for scripts

2006-06-14 Thread Michael Stassen
Graham Reeds wrote: I have posted a similar question on the blojsom group but I feel I will have better chance of an answer here. Blojsom 3 was developed using MySQL5 for it's back end. However the host I am with uses 4.0.25 and are unwilling to upgrade - which is fair enough. So I decided

Re: Differences between MySQL 4 and 5 for scripts

2006-06-14 Thread Dan Buettner
Graham, I seem to recall those single quote marks working without a problem on various platforms and versions of MySQL. Of course they are generally just a nicety and only required if you are using reserved words as table/column/key names, so you could just remove them entirely. Could you po

Differences between MySQL 4 and 5 for scripts

2006-06-14 Thread Graham Reeds
I have posted a similar question on the blojsom group but I feel I will have better chance of an answer here. Blojsom 3 was developed using MySQL5 for it's back end. However the host I am with uses 4.0.25 and are unwilling to upgrade - which is fair enough. So I decided to see what I can do