Page 1 of 1

[SOLVED] Ticket Messages are cut if german umlauts äöüß in

Posted: Wed Nov 09, 2011 10:23 am
by tpoth
Script URL:
Version of script:
Hosting company:
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution: UMLAUT, GERMAN TICKET SAVE

Write your message below:

Dear Board,

I installed hesk 2.3 on our hosting Webspace in Germany called Mittwald
The installed software on this host ist as follows:
- PHP 5.3.8
- MYSQL 5.0

Now if i try to save any German characters, like äöüß, the text in the db will be cutted at the german characters position.

Do you have any hints.

If i load the text back from the db, i.e. any tickets, the text ist cut.
I think, that's because of a security feature.

Hesk is a really nice looking software, it would'nt be nice if i can't use it in germany.

Regards
Thomas

Re: Ticket Messages are cut if there are german umlauts äöüß

Posted: Wed Nov 09, 2011 10:43 am
by Klemen
This is something your hosting company is truncating, it's not a HESK security feature.

I tested it in the demo and it works fine there:
http://www.hesk.com/demo/ticket.php?track=E9J-MAV-X4HB

Do you use the translated (German) version or English?

Re: Ticket Messages are cut if there are german umlauts äöüß

Posted: Wed Nov 09, 2011 11:07 am
by tpoth
I've downloaded the english version and put the translated de directoy from this board on the server.
That's it.

I'll have a look into the database.
maybe there's an encoding problem.

Thx Thomas

The DB seems to work fine.
The collation is utf8_unicode_ci

I inserted any äöü in a phpmyadmin session to a ticket directly

if i view the ticket in hesk there is shown Image

The To chars after W in the second line was entered in the phpmyadmin as ä.

any idea?

Re: Ticket Messages are cut if there are german umlauts äöüß

Posted: Wed Nov 09, 2011 11:35 am
by Klemen
Try using this file instead (upload to your "language/de/" folder):
http://www.phpjunkyard.com/extras/text.zip

Then close all browser windows, open HESK again, refresh the page and see if you can now post normally.

Re: Ticket Messages are cut if there are german umlauts äöüß

Posted: Wed Nov 09, 2011 11:50 am
by tpoth
Thx that worked for me.

What's the difference between these files.

I'm realy happy to test your solution now.

Re: [SOLVED] Ticket Messages are cut if german umlauts äöüß

Posted: Wed Nov 09, 2011 11:58 am
by Klemen
The new files has encoding set to UTF-8 and saved as a UTF-8 encoded file without byte mark order.

Glad to hear it worked.