Before I begin to explain my problem, I just want to say that I can do the following two things:
1. Using Perl, connect to a MS Access Databse Table and perform the required operations.(Dat abase is in English language)
2. I can read and write UTF8 text files using Perl.
The following code explains how do I write UTF8 files.:
[CODE=perl]$infile="out2.t xt";
#$outfile="out. txt";
#open (FH,">:utf8",$o utfile);
open(F,"<:utf8" ,$infile);
while(<F>){
chomp;
binmode(STDOUT, ":utf8");
print "$_"."\n";
}
if($_ == /\x{0932}/)
{
print "L";
}
$strvar="\x{093 2} \x{0917}";
print $strvar."done". "\n";
#print FH $strvar."\n";
close(F);[/CODE]
Here, I am reading from one UTF8 file and writing to another UTF8 file. Also, in the new UTF8 file I am adding two more characters whose hex values are there in the variable "strvar" as can be seen in the program. Now when I see this file in Wordpard or Notepad everything is fine.
Now I come to my question.
I have enabled Hindi Language/Internationaliz ation support on my machine. If I directly try to write Hindi to the tables in MS Access, I am able to do that. Now the problem is that when I try to insert a string into MS Access from Perl whose Hex value(Unicode) is \x{0932} it does not appear correctly in the table. The Character that should appear corresponding to 0932 Hex is shown below(You can see this if you have Unicode support on your machine).
ल
However, instead of the above character, some garbled character is displayed on the screen. I dnt know how to insert unicode characters into MS Access from Perl(That is issuing a insert query from Perl to insert unicode strings). I need urgent help on this. I would really appreciate if someone could help me out.
thanks in advance.
Kanwaljeet
1. Using Perl, connect to a MS Access Databse Table and perform the required operations.(Dat abase is in English language)
2. I can read and write UTF8 text files using Perl.
The following code explains how do I write UTF8 files.:
[CODE=perl]$infile="out2.t xt";
#$outfile="out. txt";
#open (FH,">:utf8",$o utfile);
open(F,"<:utf8" ,$infile);
while(<F>){
chomp;
binmode(STDOUT, ":utf8");
print "$_"."\n";
}
if($_ == /\x{0932}/)
{
print "L";
}
$strvar="\x{093 2} \x{0917}";
print $strvar."done". "\n";
#print FH $strvar."\n";
close(F);[/CODE]
Here, I am reading from one UTF8 file and writing to another UTF8 file. Also, in the new UTF8 file I am adding two more characters whose hex values are there in the variable "strvar" as can be seen in the program. Now when I see this file in Wordpard or Notepad everything is fine.
Now I come to my question.
I have enabled Hindi Language/Internationaliz ation support on my machine. If I directly try to write Hindi to the tables in MS Access, I am able to do that. Now the problem is that when I try to insert a string into MS Access from Perl whose Hex value(Unicode) is \x{0932} it does not appear correctly in the table. The Character that should appear corresponding to 0932 Hex is shown below(You can see this if you have Unicode support on your machine).
ल
However, instead of the above character, some garbled character is displayed on the screen. I dnt know how to insert unicode characters into MS Access from Perl(That is issuing a insert query from Perl to insert unicode strings). I need urgent help on this. I would really appreciate if someone could help me out.
thanks in advance.
Kanwaljeet
Comment