To get things started, I was having major issues until I changed your two instances of encoding(UTF-8) to utf8.

Next, are you sure you want \x{feff}? When I get rid of it, I start getting things quoted: 

Row 1, Col 1 Is Quoted:  Row1Col1
Row 1, Col 2 Is Quoted:  Row1Col2
Row 1, Col 3 Is Quoted:  Row1Col3
Row 2, Col 1 Is Not Quoted:  Row2Col1
Row 2, Col 2 Is Not Quoted:  Row2Col2
Row 2, Col 3 Is Not Quoted:  Row2Col3
Row 3, Col 1 Is Not Quoted:  Row3Col1
Row 3, Col 2 Is Quoted:  Row3Col2
Row 3, Col 3 Is Quoted:  Row3Col3
Row 4, Col 1 Is Quoted:  Row4Col1
Row 4, Col 2 Is Not Quoted:  Row4Col2
Row 4, Col 3 Is Quoted:  Row4Cþol3
Row 6, Col 1 Is Not Quoted:  Row5Col1
Row 6, Col 2 Is Not Quoted:  Row5Col2
Row 6, Col 3 Is Quoted:  Row5
Col3

[download]

also, it gets rid of the weird þ characters. One more thing, your input file isn't formatted consistently... There are some /n and double \x{fe}\x{fe} characters where I don't think you intended them to be.

In reply to Re: Non-ASCII Characters As Separators/Quotes/Escapes When Using Text::CSV_XS by frozenwithjoy
in thread Non-ASCII Characters As Separators/Quotes/Escapes When Using Text::CSV_XS by Jim

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.