shuttle-export icon indicating copy to clipboard operation
shuttle-export copied to clipboard

not support utf8

Open myehrajat opened this issue 5 years ago • 2 comments

myehrajat avatar Nov 26 '18 19:11 myehrajat

I fixed this here Pull https://github.com/2createStudio/shuttle-export/pull/17 Image 33

P.S I fixed this base on namespaced branch

https://github.com/2createStudio/shuttle-export/tree/namespaced

dolphinotaku avatar Jul 24 '19 16:07 dolphinotaku

Hello Guys,

For this tool to support fully UTF8 you need to add two lines only:

In class Shuttle_DBConn_Mysql extends Shuttle_DBConn:

function connect() {
	$this->connection = @mysql_connect($this->host, $this->username, $this->password);
	mysql_set_charset('utf8',$this->connection); // This is the new line number 1
            RESTOFTHEFUNCTION(...);

And in Shuttle_DBConn_Mysqli extends Shuttle_DBConn class:

function connect() {
	$this->connection = @new MySQLi($this->host, $this->username, $this->password, $this->name);
	mysqli_set_charset($this->connection,'utf8'); // This is the new line number 2 
            RESTOFTHEFUNCTION(...);

And then have fun with the world UTF8 :-) We only need to add ROUTINES export as well to fully backup the DB.

shangab avatar Mar 23 '21 15:03 shangab