SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 08:35 AM
| ||||
| ||||
 preserving trailing space in a stored string how can I save a string like this "aaaa " ? It seems that MySQL CHAR type doesn't save the trailing space.... I need that to store French prepositions (some need to be concatenated directly to a name, others need a space... thanks joss      |
|
02-28-2008, 08:35 AM
| ||||
| ||||
| Re: preserving trailing space in a stored string Josselin wrote: > how can I save a string like this "aaaa " ? It seems that MySQL CHAR > type doesn't save the trailing space.... > I need that to store French prepositions (some need to be concatenated > directly to a name, others need a space... > > thanks > > joss > > This depends on what version you are using. Before 5.0.3 you will need to store the values in a TEXT or BLOB, in 5.0.3 and on, a VARCHAR will prevail the trailing spaces. hth /zw |
Linear Mode
