blank space in mySQL

[Anon]

Hi,

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?

[Anon]

Why dont you just put in a special character and then we you export it, you can str_replace that special char later on.

[micfur]

The problem with that is the text file is being imported into a PDB (PDA Database) file and we want to minimise the work on the PDA side.

Anyway I found a solution. I was defining my types as varchar and by moving them to a text type this will export a single space by default. I know text types take more space but the database isnt very big anyway.

Thanks for the help