MyBB Community Forums

Hi all, excuse my English is that I speak Spanish and I use google translator


I have a problem, I'm trying to make a mysql query the latest issues, and after that display it on another page in an iframe

but the problem is that the iframe not showing special characters

and got: <meta content="text/html; http-equiv="content-type" charset=UTF-8">

I worked nor


This is where I do the query:
http://foronet.net/temas.php

and here is where the iframe:
http://foronet.net/

as you can see the characters lso problem

What else I can do?


I appreciate your help

I think you have to set the correct character set for your MySQL database. You can find your character set and how to do that here for MySQL 5.0 and above: http://dev.mysql.com/doc/refman/5.0/en/charset.html

Here in spanish: http://dev.mysql.com/doc/refman/5.0/es/charset.html

(2013-10-27, 11:00 PM)QuantumHive Wrote: [ -> ]I think you have to set the correct character set for your MySQL database. You can find your character set and how to do that here for MySQL 5.0 and above: http://dev.mysql.com/doc/refman/5.0/en/charset.html

Here in spanish: http://dev.mysql.com/doc/refman/5.0/es/charset.html

Hello, I understand, but if I show them well in mysql query

it shows me wrong in the iframe

Hmm I see, the database charset should be configured correctly, since it shows the characters correctly on your forums and threads (e.g. here: http://foronet.net/showthread.php?tid=96.

I don't think it has something to do with the html charset on the clientside. Do you have access to the database? If yes, look up the tables and see how they are saved in there.
How are you querying these texts into your iframe?

Hi, cotegamiento of the database is utf8_general_ci and shows me the data with special characters in database

here do the query: http://foronet.net/temas.php do very well here

the problem in the index.php


I realize now I think the problem is that something interferes with something the forum


for if I do another frame apart without anything at all like here: http://foronet.net/iframe.php

show me the perfect


I think the problem with the forum thing

But what will?

You say that the characters are showing correctly at http://foronet.net/temas.php right? For me it doesn't, it looks the same as your index.php page:


Also for http://foronet.net/iframe.php:


As you can see the characters are also not showing correctly in the source.
What do you think is interfering?

Hi, will this be browser problem

because I thought it was problem of mybb forum because I do not show it

Now I see in the mozilla browser also displays the error


google browser but it shows well

Hmm I see, Firefox gives me this warning:

Quote:The character encoding of the HTML document was not declared. The document will render with garbled text in some browser configurations if the document contains characters from outside the US-ASCII range. The character encoding of the page must be declared in the document or in the transfer protocol. @ http://foronet.net/temas.php

Could you fix this first?

Hello and the problem is solved

what I had to do in the mysql query was this: mysql_set_charset ('utf8')
and ready mlo shows me all ok


thanks anyway


regards

______
is a question where you saw AWARNING or is that the time?

Good!

I'm glad your problem is fixed and we could work this through.

The characters are showing correctly now for me:


Also at http://foronet.net/temas.php: