Problem in fetching special character like ® from database through TPL

Hi,

I wrote a tpl which is opening a database connection and fetching values from table. I am printing these values into aspx pages. All datas are printing fine in resulting page but the coulmns which are having special characters like ® or © are giving null values.

Below is TPL code :

database.lib file is having all database details.

print "Content-type: text/html; charset=utf-8\n";
	require "C:\\Interwoven\\TeamSite\\httpd\\iw-bin\\jppl\\database.lib";
	use DBI;
	use utf8;				
	use Encode;
	use HTML::Entities;
	$ENV{'NLS_LANG'} = ".UTF8";
	my $dbh=&connectDB();

I also tried with other encoding as well but no luck.

I am using Teamsite version 7.4.1 installed on windows 2012 server.

My databse is SQL installed on windows server.

Any help would be apprciated.

Thanks,

Niraj Kumar

Find more posts tagged with

Comments

Pauliw

Hi,

1) How do you insert these special characters data in DB ,Are you using utf_encode() on the columns , check the Collation ?

2) if yes while retriving after connecting to DB are you setting the character set of the connection ?

Thanks

Paul

nirajk wrote:
Hi,

I wrote a tpl which is opening a database connection and fetching values from table. I am printing these values into aspx pages. All datas are printing fine in resulting page but the coulmns which are having special characters like ® or © are giving null values.

Below is TPL code :

database.lib file is having all database details.
print "Content-type: text/html; charset=utf-8\n";
	require "C:\\Interwoven\\TeamSite\\httpd\\iw-bin\\jppl\\database.lib";
	use DBI;
	use utf8;				
	use Encode;
	use HTML::Entities;
	$ENV{'NLS_LANG'} = ".UTF8";
	my $dbh=&connectDB();
I also tried with other encoding as well but no luck.

I am using Teamsite version 7.4.1 installed on windows 2012 server.

My databse is SQL installed on windows server.

Any help would be apprciated.

Thanks,
Niraj Kumar

Rick Poulin

Maybe it's not about how you're reading them but how you're printing them out? If you print the values to a plain text file, what happens?

If you inspect your database directly with the MSSQL tools, are the values correctly displayed in the database itself?

nirajk

Hi,

We are setting data in database via DCR and in database value is displaying just fine.

In text file also value is printing as expected.

I dont know where to look next. I tried every other solutions availabel on the net also.

Thanks in advance!

Niraj Kumar

nirajk

Thanks all for suggestion. Finally I got the the solution.

It was an encoding issue.

I used this module use HTML::Entities;

I set this encode entity to the variable and it gave the exact value.

my $encoded = encode_entities($your-varable);

Regards,

Niraj Kumar.