Page 1 of 1

database encoding

Posted: Tue Dec 06, 2011 4:14 pm
by kabuc
I have a big problem. I want to found data in my database but I can't because all spec latin letters are writed in unknown symbols... Can it be that hesk send data not unicode text?
Now I have a lot much data and all are bad.
This is examples what happens:
http://img822.imageshack.us/img822/1396/42420182.png
http://img716.imageshack.us/img716/6996/19940193.png

Re: database encoding

Posted: Sat Dec 10, 2011 2:13 pm
by Klemen
This is not bad data, it has just been turned into HTML entities - code to show properly on HTML pages without matching encoding.

All the data should still show correctly in all HESK tickets and also when editing tickets from within HESK.

Re: database encoding

Posted: Sun Dec 11, 2011 10:53 am
by kabuc
but if I want to search for data within MySQL is not for the wrong characters. It is not, in any CMS, etc. do not write to mysql data in a way because if you need search a MySQL simply will not go dig up, our system admin also said that it should not be.

Re: database encoding

Posted: Sun Dec 11, 2011 12:16 pm
by Klemen
Have you set HESK encoding to an encoding that supports your special chars? Like utf-8? And does your MySQL database have the exact same encoding?

Re: database encoding

Posted: Sun Dec 11, 2011 12:25 pm
by kabuc
Yes, I guess what I have already modified hesk sends letters to mysql