Jump to content

Problem with Charset

agustin

By agustin
in Using WHMCS

 Share

Recommended Posts

blymp Senior Member

blymp

Posted
Posted

Anybody found another easier solution?

 

I also have this charset issue. My WHMCS is running with ISO-8859-1 and I rarely get mess up e-mails but sometimes I get, depending of the client.

 

But one annoying thing is that I can't edit answers on the ticket log, it saves in UTF-8.

Anybody knows if I can change the default chatset on the editor to ISO-8859-1, and if it would cause any other problem on the system?

 

Thanks!

0
Link to comment
Share on other sites
papapan Junior Member

papapan

Posted
Posted

Hi! Did you find any solution? I have exactly the same problem with Greek. My WHMCS is running with UTF-8 and the Greek characters in e-mails from Google apps Gmail come in ISO-8859-7.

In WHMCS administration when changing encoding from utf-8 to iso-8859-7 I can see the right characers instead of �

But the real problem is in the auto respond e-mail that a client receives when a ticket is opened, where the client receives some non readable characters instead of his e-mail text.

 

Thanks!

0
Link to comment
Share on other sites
papapan Junior Member

papapan

Posted
Posted

So, I think that the right solution would be to change the message and subject encoding in the database and have all messages in utf-8 encoding, as the WHMCS uses.

But i have tried http://www.php.net/manual/en/function.iconv.php http://de.php.net/manual/en/function.utf8-encode.php and http://de.php.net/manual/en/function.imap-utf8.php

and noone seems to give the solution.

Any suggestions? :?:

Thanks!

0
Link to comment
Share on other sites
papapan Junior Member

papapan

Posted
Posted

I hope they will find a solution quickly.

I used http://www.phpclasses.org/browse/package/1360.html and the test page is working! The Greek characters from the database appear as it should.

I will try later to make the hook also.

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">  
<html xmlns="http://www.w3.org/1999/xhtml">  
<head>  
<meta http-equiv="content-type" content="text/html; charset=utf-8" />  
<title>Encode testing</title>  
</head>  
<body>  

<?php 
require_once "includes/ConvertCharset/ConvertCharset.class.php";

// Encode testing 

mysql_connect('localhost:3304', 'user', 'pwd'); 
mysql_select_db('dbname'); 

// Read first 5 tickets 
$sql = "SELECT id, tid, title, message FROM tbltickets LIMIT 5"; 
$res = mysql_query($sql); 

// For each ticket 
while(list($id, $tid, $title, $message) = mysql_fetch_array($res)) { 
   // Shows generic info for this ticket 
   echo "[$id] "; 
   echo "<strong>$title</strong><br />\n"; 
   echo "<p><strong>Before</strong><br />$message</p>\n"; 

   // Check if encoding is utf8 
   $enc = mb_detect_encoding($message, "UTF-8, ISO-8859-7"); 
   if($enc!="UTF-8") { 
			$Entities = 0;
			$FromCharset = $enc;
			$ToCharset = "UTF-8"; 
			$text = new ConvertCharset($FromCharset, $ToCharset, $Entities); 
			$message = $text ->Convert($message);
	// and print fixed message 
       echo "<p><strong>After $enc</strong><br />$message</p>\n"; 
   } 
   echo "<hr />\n"; 
} 

?> 

</body> 
</html>

0
Link to comment
Share on other sites
  • 3 weeks later...
  • 3 months later...
  • 6 months later...
  • 5 months later...
sochart Junior Member

sochart

Posted
Posted

Same problem here,

I try to print labels with Nicelabel and Labelview by using MyODBC driver and Nicelabel native MySQL support.

Same problem, all accents are destroyed.

If I use EMS MySQL Manager, a front-end, same result as I browse the DB.

WHMCS team, please reply ?

0
Link to comment
Share on other sites
  • 6 months later...
  • 3 weeks later...
Patty Senior Member

Patty

Posted
Posted

Matt once again to the rescue:

 

And for the charset issue on tickets, I'm suspecting there's some kind of issue with the PHP iconv library on your server causing this so please try adding the following line to your WHMCS configuration.php file and see if this helps at all.

 

$disable_iconv = true;

Worked like a charm! No more problem with funny characters on my tickets. :)

 

Thank you, Matt!

0
Link to comment
Share on other sites
ditto Senior Member

ditto

Posted
Posted

Thanks. Adding $disable_iconv = true; to configuration.php also fixed the issue for me. For several years I have had the problem with special characters that display wrong not readable. I am using iso-8859-1 in WHMCS. I have also asked Matt in support tickets years ago for help, but he did not have a solution. But this fixed it!

 

So I guess the rule will be that if you have iso-8859-1 in WHMCS, then you need to add this fix.

0
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated

  I accept