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

andreb · Post by **andreb** » Tue Sep 20, 2011 5:58 am

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

Post by **HighAley** » Wed Sep 21, 2011 1:28 am

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.

andreb · Post by **andreb** » Wed Sep 21, 2011 2:53 am

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.

Post by **Vladimir** » Thu Sep 22, 2011 3:20 am

Hello,

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

Thank you.

andreb · Post by **andreb** » Thu Sep 22, 2011 4:56 am

Hello Vladimir,

Fieldtype is text.

andreb · Post by **andreb** » Thu Sep 22, 2011 5:12 am

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.

Post by **Vladimir** » Thu Sep 22, 2011 8:41 am

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.

andreb · Post by **andreb** » Thu Sep 22, 2011 10:38 am

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.

Post by **Vladimir** » Fri Sep 23, 2011 2:04 am

Hello, André

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

Thank you.

andreb · Post by **andreb** » Fri Sep 23, 2011 6:44 am

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!