Garbage data while inserting data with special characters in SQL Server 2012 using Perl
I have an XML file with data in multiple languages (eg. - Russian, Japanese, Chinese, English). This XML is created on Linux platform and it has passed xmllint checks.
Now, I am reading this data from XML file and inserting into SQL Server 2012 on Windows 7 platform (XML also present on Windows). But I am getting ???? as a value in fields. This is happening for some of the cases like all the sentence in other language.
But, if any sentence having some special characters it's working fine.
I am using function
$row_value = decode("utf-8",$row_value);
use Encode; require Encode::Detect; my $utf8 = decode("Detect", $data);
Try this for decode data...