I have a script that gets a string from the database, splits it into words and writes the words to the database. It works perfectly when i call the script via http (using apache web server). It also works to run it from a windows command line. However, when i try to run it from the command line (shell) in ubuntu all swedish chars ÅÄÖ is replaced with AAO in the database. Very strange.
What is apache telling php that i need to tell it myself when running from command line?
Probably ubuntu does not accept Terminal that kind of stuff. Try to install a addon or so?
It isnt really strange cause almost all command line stuff have some problems with some special chars. Are you sure you really need that? Is there not an other way to write it? I dont know cause im not swedish.
Apache and PHP just have support for that kind of chars,,, there is nothing to say else
MySQL has various parameters dealing with client encoding. Setting the client character set either to UTF-8 or to the database's character set should solve your problem.
You could put phpinfo() at the top of your script, to print all your environment variables, configuration settings, etc. Compare the output when running at the command line vs running under apache.
Often there will be a different php.ini file that gets used when run via the command line. Check to see if you have one, and what the differences are.