NYCPHP Meetup

NYPHP.org

[nycphp-talk] MySQL and spaces in data

tom at supertom.com tom at supertom.com
Thu Jun 19 10:48:39 EDT 2003


Jeff,

What does your insert query look like, and what type of column are you
inserting into?  I can't yet see why this would happen (spaces replaced with
underscores).

Tom



-----Original Message-----
From: Jeff [mailto:jsiegel1 at optonline.net]
Sent: Thursday, June 19, 2003 10:50 AM
To: NYPHP Talk
Subject: [nycphp-talk] MySQL and spaces in data


How does MySQL handle the following?

I'm trying to save a car model called "1600 DUETTO SPIDER."
I noticed it saves it with underscores.

What happens when I retrieve that data in a query? Does it come back as
1600_DUETTO_SPIDER?
Or, if I need to retain the spaces, do I do something like %20 or
something like   when I save the data?

Jeff



--- Unsubscribe at http://nyphp.org/list/ ---





More information about the talk mailing list