character encoding with mysqli

Hi

I'm having a strange encoding issue. Everything is set to utf-8 (the database, fields, web pages etc) but on

http://121t.co.uk/booking-and-availability.html you can see that the pound sign is not displaying properly. This page uses mysql_i

whereas the same info but on a test mysql connection displays properly:

http://121t.co.uk/Detail.php?pg_id=10

I've tried deleting anything different on the mysql_i page, but can't find anything that makes a difference!

Any help much appreciated, as always

Chris

Can I get a copy of the two connection files? I'm thinking the connection itself has different encoding.

Thanks Ray

pm

Hi Ray

I've deleted the last line from the mysql_i connection script, and all works properly now!
Cheers
Chris

That probably means the charset specified in the mysql database itself is not utf-8

Hi Ray

Haven't checked that - but I restored the last line and change the utf8 part to utf-8 and it also now works

set_charset('utf-8');

Don't know if it's ignoring this line because it's invalid, therefore it's treated like it's not there!

Still googling how to find the db characterset!

Thanks
Chris

That is the mysql version and not the mysqli version of the charset code. If you did restore the last line it would have looked like:

$conn121_i->set_charset('utf-8');

So yes, that line is essentially ignored... and 'utf8' is the correct syntax.

Like I said earlier, that should match the charset specified in your mysql database itself and you probably aren't using utf8 there.

I'm having a problem with encoding. I checked and confirmed both the database table and the MySQLi connection is set to UTF8. When I store URL address (http://adventsite.live/communities/), it stores it correctly in the table, but when it retrieves it via <?php echo($rsSlides->getColumnVal("link")); ?>, it prints http:&#x2F;&#x2F;adventsite.live&#x2F;communities&#x2F;" (see line 194 of view-source:http://adventsite.live/).

The MySQLi class has automatic Cross Site Scripting protection that prevents HTML from being displayed. To override that just change:

<?php echo($rsSlides->getColumnVal("link")); ?>

to:

<?php echo($rsSlides->getColumnVal("link",false)); ?>

This worked great. Thanks.