3

I've recently transferred my webapp from my localhost (LH) to a VPS, and have had hebrew chars-encoding probs since. Whenever I send a request with a heb-char it results in "?????" saved to the DB.

My LH config was tomcat6, MySQL, and centOS 6.2, opened to the web. In the VPS env I'm behind an Apache Web Server, and the rest is quite the same (though I haven't done anything to its installation). Please note I already have had this problem before, on my LH when the request was sent from IE/chrome (not FF!). The solution was to apply a filter on the the context and change the char-type to UTF-8.

My webapp content char-encode is utf-8, MySql server set to utf8 using charset utf8;, and my centOS set to iw_IL.UTF8 using export LANG=iw_IL.UTF8. When I use locale the bash output seems to be set correctly.

Any suggestions?

DerfK
  • 19,493
  • 2
  • 38
  • 54
OBY
  • 31
  • 1
  • 2

2 Answers2

1

Make sure in my.cnf and php.ini that all the connections are encoded with utf8

my.cnf

[mysqld]
default-character-set=utf8
default-collation=utf8_general_ci
character-set-server=utf8
collation-server=utf8_general_ci
init-connect='SET NAMES utf8'

[client]
default-character-set=utf8

php.ini

default_charset = "utf-8"
omercnet
  • 158
  • 6
  • Welcome to Server Fault! Whilst this may theoretically answer the question, [it would be preferable](http://meta.stackexchange.com/q/8259) to include the essential parts of the answer here, and provide the link for reference. – Scott Pack Oct 31 '12 at 01:35
-2

just leave empty 'default_charset' in WHM :::::: default_charset =''

p.s. In WHM go --------) Home »Service Configuration »PHP Configuration Editor ----) click 'Advanced Mode' ----) find 'default_charset' and leave it blank ---- just nothing, not utf8, not ISO

grrow
  • 1
  • 1
  • 1
    Could you please elaborate a bit on your answer? Which configuration file? It would prove valuable for future users searching for solutions. – John K. N. Nov 04 '16 at 10:31
  • 1
    In WHM go --------) Home »Service Configuration »PHP Configuration Editor ----) click 'Advanced Mode' ----) find 'default_charset' and leave it blank ---- just nothing, not utf8, not ISO – grrow Nov 05 '16 at 10:28