Page 1 of 2

Stand alone viewer is ok, but Web viewer shows strange characters for some bands.

Posted: Tue Sep 20, 2011 5:58 am
by andreb
Hi,

I am new here. I bought reports.fx for php some days ago and the features are great!
But I'm puzzled by a problem with characters which prevents me from deploying my reports.

When I view my report with the viewer of the stand alone designer, all characters are perfect.
However, when I deploy the .mrt file to my local server, parts of the text look strange. As if the webviewer uses a wrong characterset.
But only some databands are wrong, some bands are fine in both standalone viewer and web viewer. (All bands are on the same report page.)

The same happens at my remote server.

Maybe there are some strange characters in my database? But than again, the stand alone viewer does not suffer from anything.
Standalone viewer and (local) webviewer use same mysql, same database and same browser.
My connection string includes charset utf8. I allowed html characters in the text. I rebuilt the report several times.
Configuration files (from quick start folder) in web server have not been changed.
I am running out of ideas where to look...

Does anyone has an idea what to check?

Thanks, André



XAmmp windows 1.7.3/mySql 5.1/Vista/Reports.FxforPHP 2011.2



Stand alone viewer is ok, but Web viewer shows strange characters for some bands.

Posted: Wed Sep 21, 2011 1:28 am
by HighAley
Hello.

For detailed answer we need :
1. Screen-shots of correct report and not correct.
2. Your connection string.
3. Sample text from database which looks strange.
4. Font name, used in text component which is displayed incorrectly.

Thank you.

Stand alone viewer is ok, but Web viewer shows strange characters for some bands.

Posted: Wed Sep 21, 2011 2:53 am
by andreb
Hello Aleksey,

1. I have attached screen shots in my first post.
2. The connection string: server=localhost;database=dbname;charSet =utf8;port=3306;uid=xxxxxx;pwd=xxxxxx;
3. Sample text can be seen in the screen shots. These include regular textstrings, utf characters, url links.
4. Font name: Arial; 8pt. I tried it using with/without using styles, but there is no difference.


Thank you for your time.


Stand alone viewer is ok, but Web viewer shows strange characters for some bands.

Posted: Thu Sep 22, 2011 3:20 am
by Vladimir
Hello,

Please tell us what type of this field used in the database?

Thank you.

Stand alone viewer is ok, but Web viewer shows strange characters for some bands.

Posted: Thu Sep 22, 2011 4:56 am
by andreb
Hello Vladimir,

Fieldtype is text.

Stand alone viewer is ok, but Web viewer shows strange characters for some bands.

Posted: Thu Sep 22, 2011 5:12 am
by andreb
Ah Vladimir, your question made me try something.

When I change the field type to VARCHAR, the report renders well.

Is field type Text not supported?

Thank you.


Stand alone viewer is ok, but Web viewer shows strange characters for some bands.

Posted: Thu Sep 22, 2011 8:41 am
by Vladimir
Hello, André

Very strange problem. We have checked VARCHAR and TEXT field types, in both cases the text have displayed correctly. The data table created in the utf8_general code page.

Please indicate that you are using a new release 2011.2 or any prerelease build? Also please tell us the PHP version.

Thank you.

Stand alone viewer is ok, but Web viewer shows strange characters for some bands.

Posted: Thu Sep 22, 2011 10:38 am
by andreb
Hello Vladimir,

Yes, I run the latest release 2011.2


Web server:

Apache/2.2.14 (Win32) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l mod_autoindex_color PHP/5.3.1 mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.10.1
MySQL-client version: 5.1.41
PHP extension: mysqli

The table data is utf8_general_ci

So I guess no obvious reasons why it shouldn't work with Text field types.

Anyway, at least I have a workaround. I can change the TEXT field types into VARCHAR. That's ok with me. :feelgood: So I will do that.

Thanks to both of you for your time.



Stand alone viewer is ok, but Web viewer shows strange characters for some bands.

Posted: Fri Sep 23, 2011 2:04 am
by Vladimir
Hello, André

If possible, please send us a small table dump and the phpinfo(), we would like to understand this error.

Thank you.

Stand alone viewer is ok, but Web viewer shows strange characters for some bands.

Posted: Fri Sep 23, 2011 6:44 am
by andreb
Yes Vladimir,

I will send it this weekend (I'm not at the office at the moment).

It will be sent to support@stimulsoft.com.

Great support!