foreach (@files) {
   open FILE, "<$ENV{'DOCUMENT_ROOT'}/data/text/$_" or die "error open
+ing $ENV{'DOCUMENT_ROOT'}/data/text/$_: $!";
[download]

$ENV{DOCUMENT_ROOT} i correct and $- is correctly set to but why not open Ένα μήνυμα σε όλους τους άπιστους.txt which is a file that does exist on /data/text ?

The answer is right there in the error message -- you just have to read it carefully. Here is just the filename string from the error message:

D:/www/data/text/D:/www/data/text/Ένα μήνυμα σε όλους τους άπιστους.txt

Can you see the problem now? You have the value of $_, which comes from a file glob, and that value is:

D:/www/data/text/Ένα μήνυμα σε όλους τους άπιστους.txt

Then, inside the loop, you append that value to this string:

$ENV{'DOCUMENT_ROOT'}/data/text/

and the result of that concatenation is that the disk and directory path appears twice in the string that is passed to "open()". Fix that, and it will probably work as intended.

I cannot believe iam THAT careless....my apologies and think you for pointing this out.

my $insert = $db->prepare( 'INSERT INTO articles (title, body) VALUES 
+(?, ?)' );

my @files = glob "$ENV{'DOCUMENT_ROOT'}/data/text/*.txt";

foreach (@files) {
   open FILE, "$_" or die "error opening $_: $!";
   
   while (<FILE>) {
      chomp;
      $insert->execute(split /\t/, $_, 2) or print $db->errstr;
   }

   close FILE;
}
[download]

gives me DBD::mysql::st execute failed: called with 1 bind variables when 2 are needed.... But iam passing it 2 vars why it says iam passing it only 1?

You need only $_


foreach (@files) { 
   open FILE, "$_" or die "error opening $_: $!"; 
... 
}
[download]


Here is a cool video at google explaining glob
http://www.youtube.com/v/j5vWBhq49ps&rel=1

I know there are complications with opening files with non-ASCII characters on windows, but don't know a lot about it. It's been discussed here before, though.
--
CollegeGear.com - more than just college gear (though, yes, we have college-branded teddy bears)