Problem with national character after migration db to another server

[puschpull]

Hello, i have problem:
this image ilustrated the problem:

http://puschpull.org/root/a/local_web.png
http://puschpull.org/root/a/local_data.png
http://puschpull.org/root/a/server_web.png
http://puschpull.org/root/a/server_data.png

http://puschpull.org/root/a/konzole_vypis_stavu_mysql_localhost.png

http://puschpull.org/root/a/phpmyadmin_localhost_tabulky_pred_exportem.png
http://puschpull.org/root/a/phpmyadmin_webserver_tabulky_wsb_po_importu.png

my problem is (maybe) like:
http://www.websitebaker2.org/forum/index.php/topic,5653.0.html
http://www.websitebaker2.org/forum/index.php/topic,6215.0.html

my trouble have 5-6 days and i not this repair
(

my language is czech, and utf-8
my site with this problem after migration:
http://puschpull.org/test_aimon/pages/sluzby/reference.php

Please Help me !!

[kweitzel]

Export / Import incompatibility ... check the export DB, maybe re-export and then do the import again.

cheers

Klaus

[puschpull]

Problem is now OK !!

 this script:
websitebaker\framework\class.database.php
edit

// Connect to the database
function connect() {
$status = $this->db_handle = mysql_connect(DB_HOST, DB_USERNAME, DB_PASSWORD);
if(mysql_error()) {
$this->connected = false;
$this->error = mysql_error();
} else {
if(!mysql_select_db(DB_NAME)) {
$this->connected = false;
$this->error = mysql_error();
} else {
$this->connected = true;
}
}
return $this->connected;
}



and instert one line:


// Connect to the database
function connect() {
$status = $this->db_handle = mysql_connect(DB_HOST, DB_USERNAME, DB_PASSWORD);
if(mysql_error()) {
$this->connected = false;
$this->error = mysql_error();
} else {
if(!mysql_select_db(DB_NAME)) {
$this->connected = false;
$this->error = mysql_error();
} else {
mysql_query("SET NAMES utf8");
$this->connected = true;
}
}
return $this->connected;
}



now works all character perfect !

[kweitzel]

... and with the next update of WebsiteBaker this change will be gone ... The permanent solution to your issue is a proper export/import of your Database.

Also, this won't work for everybody, since lot's of servers work with local character settings which are incompatible.

A note on the sde: Please use the "Codefunction" in the forum to highlicht code. You find this function hiddden in the "#" button, second row of icons, the third from the left.

cheers

Klaus

[puschpull]

how i make highlight  one line in "code"?

Code:

// Connect to the database
function connect() {
$status = $this->db_handle = mysql_connect(DB_HOST, DB_USERNAME, DB_PASSWORD);
if(mysql_error()) {
$this->connected = false;
$this->error = mysql_error();
} else {
if(!mysql_select_db(DB_NAME)) {
$this->connected = false;
$this->error = mysql_error();
} else {
mysql_query("SET NAMES utf8");
$this->connected = true;
}
}
return $this->connected;
}

[kweitzel]

I see what you mean, you could use the "quote" function like this:

// Connect to the database
function connect() {
$status = $this->db_handle = mysql_connect(DB_HOST, DB_USERNAME, DB_PASSWORD);
if(mysql_error()) {
$this->connected = false;
$this->error = mysql_error();
} else {
if(!mysql_select_db(DB_NAME)) {
$this->connected = false;
$this->error = mysql_error(); 
} else {

mysql_query("SET NAMES utf8");  // this line was added!

$this->connected = true;
}
}
return $this->connected;
}

cheers

Klaus

[puschpull]

Thanks!