Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Extra character at end of each row after CSV impor

forums › forums › SQLyog › Using SQLyog › Extra character at end of each row after CSV impor

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • December 15, 2004 at 4:03 am #16703
      Ritesh
      Member

      The square seems to be some sort of control character.

      What do you mean by:

      Quote:
      the end of each row

      Are you getting the characters in the actual data or in the result display window?

    • December 15, 2004 at 5:39 pm #16704
      caves
      Member

      You should use rn as your “Line Terminate By” , that will solve your problem.

    • December 15, 2004 at 7:55 pm #16705
      showson1
      Member
      caves wrote on Dec 15 2004, 05:39 PM:
      You should use rn as your “Line Terminate By” , that will solve your problem.

      caves,

      That did the trick… thanks a lot!

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.