Website and Server Administration Forum

**3pel** · 07-10-2008, 05:54 AM

i have problems dispayig character like eurosign on my testing server everyngs works fine
the data comes from a mysqldatabase with php
but if i look with phpmy admin everything looks file in database

what configuration settings do i have to check
php? doctype?mysql?server?

these are my configurations

MySQL Karakterset: UTF-8 Unicode (utf8)
MySQL verbindingscollatie: UTF-8 Unicode (utf8)
column collocation: latin1_swedish_ci

Greetings bert

**tripy** · 07-10-2008, 06:06 AM

I'd say more the encoding of your pages than the db side.
I never have been confronted to it, but I know PHP have a really poor unicode support. So, if you do apply string functions on your resultset, the problem could lie there too.

But first, I'd check that the web page encoding is utf-8, and not ascii nor iso-8859-*

**3pel** · 07-10-2008, 06:18 AM

but if i look at the page on my testserver everything alright( page-encoding is utf 8)

**tripy** · 07-10-2008, 12:15 PM

ok, on your test server it is, but what about your prod server ?

Is your prod server a byte perfect copy of your dev server ?
It might be a default configuration set to us-ascii, rather than utf-8 that is used by default.
If your server local is set to utf-8, and the server is set to C, then it will be different.

**3pel** · 07-10-2008, 03:27 PM

it is the same on the production server

Code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" 
"http://www.w3.org/TR/html4/loose.dtd">
<!-- saved from url=(0014) about:internet -->
<html>
<head>
<title>XXXXXXXXXXX.: muziekcafe :. - Nieuws</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

i even puted a file .htaccess with this content

Code:

AddDefaultCharset utf-8
AddCharset utf-8 .txt .html .htm

any other ideas

**tripy** · 07-10-2008, 06:48 PM

Hmmm, no.
Like that, I don't see.

Maybe, try to install something like "tamper data" or "livehttpheaders" to firefox, to see what headers the server sends. Both extension allows you to inspect the server received headers.
Maybe the headers and the meta tags are different.

Tamper data: https://addons.mozilla.org/en-US/firefox/addon/966
livehttpheaders: http://livehttpheaders.mozdev.org/

**3pel** · 07-10-2008, 07:08 PM

production server

Host=xxx.xxxx.be
User-Agent=Mozilla/5.0 (Windows; U; Windows NT 5.1; nl; rv:1.8.1.15) Gecko/20080623 Firefox/2.0.0.15
Accept=text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
Accept-Language=nl-be
Accept-Encoding=gzip,deflate
Accept-Charset=ISO-8859-1,utf-8;q=0.7,*;q=0.7
Keep-Alive=300
Connection=keep-alive
Cache-Control=max-age=0

Status=OK - 200
Date=Thu, 10 Jul 2008 21:57:05 GMT
Server=Apache/2.2.3 (Debian) PHP/5.2.0-8+etch10 mod_ssl/2.2.3 OpenSSL/0.9.8c
X-Powered-By=PHP/5.2.0-8+etch10
Keep-Alive=timeout=15, max=100
Connection=Keep-Alive
Transfer-Encoding=chunked
Content-Type=text/html; charset=utf-8

test server
Host=127.0.0.1
User-Agent=Mozilla/5.0 (Windows; U; Windows NT 5.1; nl; rv:1.8.1.15) Gecko/20080623 Firefox/2.0.0.15
Accept=text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
Accept-Language=nl-be
Accept-Encoding=gzip,deflate
Accept-Charset=ISO-8859-1,utf-8;q=0.7,*;q=0.7
Keep-Alive=300
Connection=keep-alive
Referer=http://127.0.0.1/xxxx/
Cache-Control=max-age=0

Status=OK - 200
Date=Thu, 10 Jul 2008 22:03:54 GMT
Server=Apache/2.2.6 (Win32) PHP/5.2.5
X-Powered-By=PHP/5.2.5
Keep-Alive=timeout=5, max=100
Connection=Keep-Alive
Transfer-Encoding=chunked
Content-Type=text/html; charset=utf-8

i see nothing spectular

**tripy** · 08:57 PM

No, your prod server sends the good header:

Code:

Content-Type=text/html; charset=utf-8

Honestly, I'm out of suggestions...
Sorry :-(

Edit:
Hmmm, no, I see something, in fact.
Your test server is an win32 5.2.5 PHP build, when your prod is PHP 5.2.0 on linux.

Like I said, PHP is known to have problem regarding multibytes character strings, and maybe there have been bug fixes between 5.2.0 and 5.2.5 that have corrected your problem ?

Can you try to install an upgraded version on your server (looks like debian, by the build name. Which might be a problem, as they are very conservative upon upgrades.)