blank spaces in mySQL

[micfur]

Hi,

I have already posted this in error in the coding forum (apologies).

Anyway

I am trying to put a single blank space into empty fields in a mySQL table. The purpose for this is to export the table to a | delimited text file using the mysql outfile function.

I have used varing attempts to write the blank space including ' ' and \s but the exported text file never has the single space that I want.

Any ideas?

[[deleted]]

How are you exporting the data?

[micfur]

Hi Vincent,

I am using the 'select into outfile' statement. Anyway I found a solution that I forgot to post (sorry).

My typesets were all varchar (to save space) and when I converted them to a text typeset I found it exports a single space to a text file by default.

The small increase in space isnt that big a problem because my database is closed at a finite size unlike say a user registration database.

Thanks for the help (again)