problem when inserting italian text characters with accents
Submitted by kristiankloeckl on Fri, 02/06/2009 - 14:57.
dear all,
i have just started using project pier and ran into an odd difficulty.
trying to insert italian text that includes accented letters (à òèé), the text insert fails. infact, when saving a project description that includes accented letters, after saving only text until the first accented letter is displayed.
does any of you have an explanation for this and a way to resolve (hopefully)?
thanks and regards,
kristian
Hi kristiankloeckl,
I had the same problem as you. Try to comment the define('DB_CHARSET', 'utf8'); sentence in config.php file. Doing that i fixed that problem.
hi johnb,
thanks for the answer. i tried to modify the row in the config.php file into
//define('DB_CHARSET', 'utf8');
but i am still having problems with visualizing accented characters as used in italian language.
any other advise?
or someone else had a similar problem?
i'd be greatful for any help.
thanks,
kristian
I had the same problem, and I decided the problem was that even though the PHP generated HTML pages were marked with the correct encoding meta tags, Apache was telling the browser to use the default encoding (Latin1) in the HTTP headers. In order to set Apache straight, I created a .htaccess text file in ProjectPier root directory, with the following contents:
AddDefaultCharset UTF-8
AddCharset UTF-8 .html
AddType 'text/html; charset=UTF-8' html