It sounds like most of the tools on your system are assuming a single-byte encoding (cp1250) for Slovenian text. If your perl script is somehow turning your spreadsheet data to utf8 strings, you would need to make sure it gets converted back to cp1250 so that the data will be coherent in the other tools that use (and display) the data.

You haven't shown any code, so I'm not sure what to recommend, but somewhere you're likely going to want to do something like this: 

use Encode;

...
# assuming $data is a scalar containing a utf8 string:
$data = encode( "cp1250", $data );

# now it contains a cp1250 string
# (utf8 flag is off, and characters are single-byte)

[download]
(updated to show that you have to "use Encode" in order to apply the "decode()" function)

... or maybe something like this: 


open( OUT, ">:encoding(cp1250)", "output.txt" ) or die "output.txt: $!
+\n";

# assuming $data contains a utf8 string:
print OUT $data;

# the string gets converted to cp1250 before being written to the file
# (no need to "use Encode" in this case)

[download]

In reply to Re: Slovenian characters problem by graff
in thread Slovenian characters problem by JackVanRamars

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.