Safari versus Firefox on data entry
New to programming so don't know how do inspect my database per your suggestion but it must be the case - it processes without the space and doesn't with it.
Anyway to answer your other questions - I am using Powerstore 3 and Safari 4.0.5. As a default when you click in the entry box for cart, short, and long description it sets the cursor after inserting a space. You can carefully click the very corner of the box and override this, however this isn't the default way someone would enter text - you cllck in the box and go.
As a comparison on the same computer I used Firefox 3.5.9 and clicked in these boxes and everything was fine - no spaces. In each case I was using the same computer (17" 2.5GHz Intel Core 2 Duo MacBook Pro).
So no huge deal now I know what the issue is - but it could be something someone using Safari could miss