Re: Pipe tag being entered into database

Are you sure those pipe symbols aren't just artifacts of the method you're using to look at the rows in your table? For instance, when I use mysql interactively to look at data I get rows of data where the columns are separated by pipes.

If you truly are printing the data immediately and exactly as it is entered in the database, then there are no pipe symbols in your data. Otherwise, you're testing the wrong thing or you're doing something else wrong.

duff

Comment on Re: Pipe tag being entered into database

Replies are listed 'Best First'.
Re^2: Pipe tag being entered into database by minixman (Beadle) on Dec 21, 2005 at 10:09 UTC
Well i thought it was that, but the file is being created on windows and you can see the ^A after each character that i am trying to extract. T did try a search and replace on ASCII chars $_ =~ s/\x41\x88//g; Which should be the ^A but that did not work. it is very strange if you open this line of the file in VI you see the ^A but if you more the file or cat it you don't	[reply]