NYCPHP Meetup

NYPHP.org

MySQL and spaces in data

Jeff jsiegel1 at optonline.net
Thu Jun 19 10:49:48 EDT 2003


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




More information about the talk mailing list