database encoding

Helpdesk for my helpdesk software

Moderator: mkoch227

Post Reply
kabuc
Posts: 69
Joined: Tue Jun 21, 2011 6:32 am

database encoding

Post 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
Klemen
Site Admin
Posts: 10145
Joined: Fri Feb 11, 2005 4:04 pm

Re: database encoding

Post 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.
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
kabuc
Posts: 69
Joined: Tue Jun 21, 2011 6:32 am

Re: database encoding

Post 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.
Klemen
Site Admin
Posts: 10145
Joined: Fri Feb 11, 2005 4:04 pm

Re: database encoding

Post 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?
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
kabuc
Posts: 69
Joined: Tue Jun 21, 2011 6:32 am

Re: database encoding

Post by kabuc »

Yes, I guess what I have already modified hesk sends letters to mysql
Post Reply