What is causing this??

[buzzt]

Somehow, I had a bunch of line breaks in one of the columns in my table which caused my table to look al staggered when viewing it. I managed to remove all the lines, but found I have a similar problem which I cannot identify. What would cause my table to look like this? With a lot of data to look at, it becomes a problem.

Like this
+-------------------+
|
|
+-------------------+

instead of this
+-------------------+
| |
| |
+-------------------+

 

[sleipnir214]

What's your interface? What application is producing this output?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[buzzt]

Just a DOS window. The strange part is that it only happens to some of the entries. The entries that contained previously contained newlines (\n) also caused this.

 

[sleipnir214]

I would dump the contents of the table to a text file, then examine that file in some text editor that has the capability of making spaces and/or newlines visible.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[buzzt]

It appears to be something with newlines, but when I remove them, it only partially fixes the problem.

Here is how I tried to remove them.

update TABLE set COLUMN=replace(COLUMN,'\n', '');

This fixes some of the problem. but not all.

 

[sleipnir214]

It's difficult to say. Again, export the data and examine it with a good text editor. You might even take a look at the output hexadecimally.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!