Mail Encoding

[Webguardian]

No I dont have that dir. I only show gd.ini imap.ini ldap.ini mysql.ini pgsql.ini, in the /etc/php.d
Should I make it?

Thanks!

[ruchida]

/etc/php.d is the correct name. Please make a file named mbstring.ini and put the line.

[Webguardian]

Okay I’ve added the file mbstring.ini file to the /etc/phpd directory with the one line extension=mbstring.so
I restarted apache then sent an email with some Japanese text to the email account used in SugarCRM and I’m sill not able to see the Japanese. I can send from SugarCRM in Japanese and see it fine on the other end. Just not to SugarCRM. Attached is a screen shot.

If you dont think there is anything left for me to try, I may just try and upgrade of PHP. Thanks for everything!

[ruchida]

Ed,
Always make sure your phpinfo() shows the mbstring section which means the mbstring functions are enabled.

If the mbstring section is not listed, it is likely the php-mbstring module is not installed in your linux OS. Please find the correct distribution here and install it.

[Webguardian]

Okay now the mbstring function is enabled and I see it showing the phpinfo(). It seems that If I force my local outlook to send in plain text UTF8 I can read that incoming email in SugarCRM. However any other normal test from 5 different Japanese computer systems could not be read. I'm not sure how to read the headers through SugarCRM but the one that is CC'd to my local computer shows the character set to be ISO-2022-JP. And it seems I cant read the subject or body of those emails.

[ruchida]

Can you input Japanese into your SugarCRM like a lead name, cantact name, etc., and see those Japanese characters correctly in SugarCRM?

How is your MySQL database created? Did you let SugarCRM create it, or did you manually created it?

What is a default character set of MySQL?

(If you can send my.cnf under /etc to me, it would be helpful.)

Can I see your phpinfo() too?

[Webguardian]

1. Can you input Japanese into your SugarCRM
Yes. I was able to type in Kanji into the contact name fields and it saved and I can see it.

2. How is your MySQL database created?
I let SugarCRM set it up during the installation process.

3. What is a default character set of MySQL?


4. Here is the contents of my my.cnf file
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

5. Here is my PHP Information https://64.34.217.9:8443/sitepreview...jp/phptest.php

[ruchida]

Ed,

Your system seems to be perfectly ready for Japanese characters. I pulled out old PHP 4.3.9 and setup the same stack as yours, tried importing emails in SugarCRM, and have not had any problem. The Japanese 4.2.0a should not have any problem in handling iso-2022-jp, euc, utf-8, or others.

Have you correctly updated your 4.2.0a with our Japanese patch? (It's different from Japanese Language pack.)

[Webguardian]

No I have not yet. I tried to a few days ago and I was getting lots of errors. However I will try again. Thanks.

Ed

[Webguardian]

Uchida-san,

Thank you very much for you help. It was tough being new to SugarCRM and them having to deal with Japanese language issues made it more difficult for me. You've been a great help. Please check your PM when you get a chance.

Kind Regards,

Ed