On Monday 24 October 2005 12:00, Bruce Martin wrote:
> Can you force it to keep the space by escaping the space?
> Something like:
>
> mysql> insert into test_strings set foo_1=' test\ ',foo_2=' test\
> ',foo_3=' test\
> ',foo_4=' test\ ';
no...doesn't work...guess i will have to use text :|
Kin
Can you force it to keep the space by escaping the space?
Something like:
mysql> insert into test_strings set foo_1=' test\ ',foo_2=' test\
',foo_3=' test\
',foo_4=' test\ ';
On Oct 24, 2005, at 5:34 AM, Andreas Steichardt wrote:
Hi!
I just hit something really strange which is either a bu
Andreas Steichardt <[EMAIL PROTECTED]> wrote on 24/10/2005 10:34:08:
> Hi!
>
> I just hit something really strange which is either a bug in MySQL or a
> dumbness bug of me.
>
> I am trying to insert a string ending with a simple space and i really
want
> this space at the end of my string ;).
Hi!
I just hit something really strange which is either a bug in MySQL or a
dumbness bug of me.
I am trying to insert a string ending with a simple space and i really want
this space at the end of my string ;). Unfortunately MySQL kills this
whitespace when inserting into normal (var)char colu
