[SOLVED] My base keeps changing some chars to ?

[Ayon]

Hey everyone

I'm stuck at a really annoying problem here...

 

well basicly what happens is that it keeps changing æ ø å Æ Ø Å to ?, and that's a pretty massive problem for me cuz I'm working on a norwegian site... I've change the base to utf8_general_ci but still doesn't work

 

Thanks in advance

- Ayon

[Ayon]

one thing i forgot to add was that... when I add an entry to the base it works.. but when i try to update the entry it replaces the letters

[corbin]

Have you changed the collation of the MySQL connection?

 

 

http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html

[Ayon]

hmm where do I change those settings? sorry but I'm new to setting up phpmyadmin on a remote host

 

EDIT: Nvm, found it...but I allready had that set to utf8_general_ci

[Ayon]

Ok here's the setup after i changed all charsets...

 

Collation: utf8_unicode_ci

Table: utf8_general_ci

All text rows: utf8_general_ci

 

Now it's stopped replacing with ? but now it just removes it...

[fenway]

What's "it" in this case... there's a php side to this issue as well.

[Ayon]

Hey again

 

First I wanna say, thanks for helping me trying to solve this issue..

I've added some info I thought could be usefull... Dunno if you need all this info but.. Well here it goes

 

MySQL:

Server: ********** via TCP/IP

Server version: 5.0.60-log

Protocol version: 10

User: ************

MySQL charset: UTF-8 Unicode (utf8)

 

Web server

Apache

MySQL client version: 5.0.56

PHP extension: mysqli

 

Query:

UPDATE `wiifan_games` SET `game_name`='hmmm', `game_released`='1136070000', `game_releasedby`='10', `game_creator`='10', `game_info`='This sentance contains the letters æ ø å & Æ Ø Å', `game_genre`='1', `game_age`='0', `game_online`='0', `game_total_players`='1', `game_rating`='3', `game_service`='1', `game_subservice`='', `game_modified`='1237309890', `game_modified_by`='1' WHERE `game_id`='12' 

 

Query result

This sentance contains the letters

 

The handler script

<?php

session_start();
require_once('../inc/functions/db.php');
require_once('../inc/functions/misc.php');
$error = array();
$id = $_POST['gameid'];
if (empty($_POST['name'])) { $error['name'] = "Må fylles ut"; }
if (empty($_POST['releasedby'])) { $error['releasedby'] = "Må fyllesut"; }
if (empty($_POST['creator'])) { $error['creator'] = "Må fylles ut"; }
if (empty($_POST['info'])) { $error['info'] = "Må fylles ut"; }
if (empty($error)) {
	DbConnect();
	foreach ($_POST as $key => $val) { ${$key} = mysql_real_escape_string($val); }
	//echo $info;
	$released = mktime(0, 0, 0, $_POST['month'], $_POST['day'], $_POST['year']);
	$modified = time();
	$modifiedby = $_SESSION['user']['user_id'];
	/*$fixchar[0] = array('æ','ø','å','Æ','Ø','Å');
	$fixchar[1] = array('æ','ø','å','&Aelig;','Ø','Å');
	$info = str_replace($fixchar[0],$fixchar[1],$info);
	$name = str_replace($fixchar[0],$fixchar[1],$name);*/
	//echo $info;
	$sql = "UPDATE `wiifan_games` SET
			`game_name`='".$name."',
			`game_released`='".$released."',
			`game_releasedby`='".$releasedby."',
			`game_creator`='".$creator."', ";
	if (isset($cover)) { 
		$sql .= "
			`game_cover`='".$cover."', ";
	}
		$sql .= "
			`game_info`='".stripslashes(str_replace($fixchar[0],$fixchar[1],$info))."',
			`game_genre`='".$genre."',
			`game_age`='".$age."',
			`game_online`='".$online."',
			`game_total_players`='".$players."',
			`game_rating`='".$ranking."',
			`game_service`='".$service."',
			`game_subservice`='".$subservice."',
			`game_modified`='".$modified."',
			`game_modified_by`='".$modifiedby."'
			WHERE `game_id`='".$id."'
	";
	echo "$sql";
	if ($result = mysql_query($sql) or die(mysql_error())) {
		if (!empty($_FILES['cover']['name'])) {
			MiscUpload('games',$id,$_FILES['cover'],'cover',2,true);
		}
		//header("Location: ../games.php");
	}
} else {
	foreach ($error as $key => $val) {
		$_SESSION['handler']['addgame']['error'][$key] = $val;
	}
	foreach ($_POST as $key => $val) {
		if (!empty($val)) {
			$_SESSION['handler']['addgame']['content'][$key] = $val;
		}
	}
	header("Location: ../games.php?vis=edit&id=$id");
}

?>

 

Let me know if you need anything else...

 

Thanks In Advance

[fenway]

Where the SET NAMES from php?

[Ayon]

hmmm do you mean the query? if so yes.. that's returned by echo $sql

[Ayon]

*bump*

[fenway]

*bump*

Solved how?

[Ayon]

hehe it was so redicolously easy... me and a designer are working side by side... he doing html i doing php.. and he had set charset to iso in the header just had to change that to utf-8 and problem was solved