<iw_perl> unable to print Symbols like © and ®

Hi,

I am trying to fetch data from DB and displaying it on the page using <iw_perl> in TeamSite.

Some data which are present in the DataBase contains Special Characters and Symbols.

Such data which contains symbols are not getting printed on the Page.

I tried to query the same in DB, the data is getting fetched in the DB.

So, I wrote a simple .pl file and tried to fetched the same data with the same query in this file.

What I found is that when I run the .pl file using the iw-perl.exe the data is getting fetched but the value displayed is wrong in the command line.

Instead of © something else is getting printed as <<.

Can someone guide me how to resolve this issue.

Thanks in Advance !

T.S. : 7.4.1

DB : SQL SERVER 2012

PERL : v5.8.2 MSWin32-x86-multi

Find more posts tagged with

Comments

Adam Stoller

You have to verify what the encoding in your DB is first.

Then you have to work with the various modules that exist for Perl (if not already present on the system, then downloadable via CPAN or similar) that work for decoding that content into something more manageable.

Finally, you have to make sure that whatever encoding your PT is outputting, that you ensure the page is rendered with that character set - usually via meta tags within the output - so that the browser renders the characters correctly.

You might be able to skip the first two steps if you can figure out a character encoding meta tag setting that works with the content as you are already getting it from the DB via the PT.

Ashraf_shk786

Thanks for the suggestion @Ghoti.

Yes, you are right that first step was to check the Encoding in the DB.

That, issue has been resolved the issue was related to encoding but after checking the same query within the DB encoding was working but after generating the page using .tpl it was creating issue and that has been resolved using encode_entities().

Using this encoding standard/function; contents and symbols on the page rendered properly.