[sdozono]

I have used SQLyog 5.23rc3 and it works nicely with SQLyogtunnel.

Thank you very much!

🙂

[sdozono]

I just found this: FYI.

http://opensource.replicator.daffodilsw.com/

Open-source project. I haven't tested yet. Some techniques are interesting.

And there is a explanation.

http://opensource.replicator.daffodilsw.co…_Resolution.htm

http://opensource.replicator.daffodilsw.co…date-Update.htm

http://opensource.replicator.daffodilsw.co…cator-help.html

http://opensource.replicator.daffodilsw.co…cator-help.html

http://opensource.replicator.daffodilsw.co…cator-help.html

[sdozono]

peterlaursen:

Thank you for taking time to experiment!

I appreciate it.

🙄

peterlaursen wrote on Oct 10 2005, 09:55 AM:

You could be a little bit more specific than just writing “Can you duplicate the problem?”  WHAT IS YOUR PROBLEM (except for your charset and other localization issues of course  :D  )

That comment was for this:

Ritesh wrote on Oct 8 2005, 03:11 AM:

Can you send me some sample data to reproduce the problem?

[post=”7481″]<{POST_SNAPBACK}>[/post]

But, I should have written it specifically!

Good suggestion. Thanks.

[sdozono]

Yes. That's right.

If that 'Create Bulk Insert statements' checkbox is OFF, SQLyog will create a dump with line feeds.

I tested phpMyAdmin.

It will make a bulk dump with line feeds.

It's like this:

INSERT INTO `languages` VALUES (1, 'English', 'en', 'icon.gif', 'english', 1),[line feeds]

(2, 'Deutsch', 'de', 'icon.gif', 'german', 2),[line feeds]

(3, 'Espanol', 'es', 'icon.gif', 'espanol', 3),[line feeds]

(4, 'Japanese', 'ja', 'icon.gif', 'japanese', 4);[line feeds]

[sdozono]

Can you duplicate the problem?

========= SOURCE(MYSQL 4.1, Tunneling) ==========

DROP TABLE IF EXISTS `TestTest`;

CREATE TABLE `TestTest` (

`id` int(11) NOT NULL auto_increment,

`name` varchar(100) NOT NULL default '',

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=ujis AUTO_INCREMENT=11 ;

—

— `TestTest`

—

INSERT INTO `TestTest` VALUES (1, ' Test. Test Data.');

INSERT INTO `TestTest` VALUES (2, 'Never Ending Synchronization…');

========= TARGET(MYSQL 4.0, Tunneling) ===========

CREATE TABLE `TestTest` (

`id` int(11) NOT NULL auto_increment,

`name` varchar(100) NOT NULL default '',

PRIMARY KEY (`id`)

) TYPE=MyISAM AUTO_INCREMENT=11 ;

#

# `TestTest`

#

INSERT INTO `TestTest` VALUES (2, 'Never Ending Synchronization…');

[sdozono]

peterlaursen wrote on Oct 8 2005, 07:57 AM:

Cna't you fix dat with the TRIM function ?

I have some data having double end-of-string encoding characters.

I remove it with

Code:

update track set filnavn = trim(trailing RIGHT(filnavn,1) from filnavn);

Thanks for this information!

I wish I had known this… I manually fixed almost 100 lines!

🙁

[sdozono]

Ok. Thank you for your explanation. I understand.

I checked Table copy from MYSQL 4.0.* to 4.0.*, there was no problem.

And even dump file also can't be loaded directly from 4.1 to 4.0..

P.S. Sync Succeeded with SQLyog 4.2 Beta5 !

I couldn't connect to MYSQL at first, though, after rebooting my PC, it goes well!

Thank you. 😆

[sdozono]

I agree with peterlaursen. And, one more thing,

>Webyog releases SQLyog v4.2 BETA 4.

>This BETA has the following bug fixes.

>– Fixed a bug with HTTP Tunneling as reported at >http://www.webyog.com/forums/index.php?showtopic=1718

this is Not a problem of SQLyogtunnel.php.

When I tried to copy DB Table from my local to remote MYSQL 4.0.23(With tunnel.php), I got this error.

==============

Error No. 1064

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version

for the right syntax to use near 'DEFAULT CHARSET=ujis' at line 5

==============

This is a problem of SQLyog itself, I think…

Thank you for your consideration in advance!

[sdozono]

Additional Info.

version()

4.1.12

[FedoraCore 4]

version()

4.1.7-nt

[Windows XP]

version( )

4.0.22-standard

[? ISP]

[sdozono]

To peterlaursen:

peterlaursen wrote on Aug 22 2005, 10:00 AM:

But I have no idea of how to implement in SJA and the TUNNELing file.

[post=”6959″]<{POST_SNAPBACK}>[/post]

phpMyAdmin can set character encodings per column basis.

Though, in my opinion, it is not user-friendly. (If you have 10 fields, and want to change encodings, you need to go to the pages of each columns, and use drop-down select, and go to next pages….. ten times!)

If SQLyog can set encodings of each columns in one page at once, it will be great!

(But, it's ok with me if SQLyog doesn't have this feature. Mainly, I'm using this SQLyog for synchronization! 😆 )

(I think the primary purpose of setting the encodings is to make sorting functions work properly.

So, if you don't need to sort Japanese data, you can put the data in 'latin1' table.)

[sdozono]

Sorry, my explanation wasn't enough…

The cause of this problem was SQLyogtunnel.php.

I tested with two servers with “MYSQL DIRECT connection”, and it worked properly!

MYSQL 4.0 -> MYSQL 4.1 Japanese encoding(ujis). => successful!

MYSQL 4.1 -> MYSQL 4.1 Japanese encoding(ujis). => successful!

But still there is a problem for php tunneling.

When you use php, you need to publish “Set character_set….” everytime after connecting to MYSQL.

In my experiment. SQLyogtunnel.php publishes “mysql_connect” repeatedly.

['Connected' shows SQLyog reconnect to MYSQL. Am I right?]

[MYSQL 4.1(DIRECT connection) => MYSQL 4.1(SQLyogtunnel.php)]

[Table copy]

=================

Connected

select version()

Connected

show variables like '%character%'

Connected

Set character_set_connection=ujis

Connected

Set character_set_results=ujis

Connected

Set character_set_client=ujis

Connected

show databases

Connected

use `test`

Connected

SET FOREIGN_KEY_CHECKS=0

Connected

drop table if exists `test`.`TestTest`

Connected

CREATE TABLE `TestTest` (

`id` int(11) NOT NULL auto_increment,

`name` varchar(100) NOT NULL default '',

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=ujis

Connected

insert into `TestTest` values ('1', 'ujis??????ujis' );insert into `TestTest` values ('2', '???????' );insert into `TestTest` values ('10', '???????' );insert into `TestTest` values ('4', '?????' );insert into `TestTest` values ('5', '????????' );insert into `TestTest` values ('6', '??????' )

Connected

SET FOREIGN_KEY_CHECKS=1

=================

I think SQLyog will work if the script goes like..

=================

Connected

select version()

show variables like '%character%'

Set character_set_connection=ujis

Set character_set_results=ujis

Set character_set_client=ujis

show databases

use `test`

SET FOREIGN_KEY_CHECKS=0

drop table if exists `test`.`TestTest`

CREATE TABLE `TestTest` (

`id` int(11) NOT NULL auto_increment,

`name` varchar(100) NOT NULL default '',

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=ujis

insert into `TestTest` values ('1', 'ujisORIGINALujis' );insert into `TestTest` values ('2', 'ORIGINAL' );insert into `TestTest` values ('10', 'ORIGINAL' );insert into `TestTest` values ('4', 'ORIGINAL' );insert into `TestTest` values ('5', 'ORIGINAL' );insert into `TestTest` values ('6', 'ORIGINAL' )

SET FOREIGN_KEY_CHECKS=1

=================

or,

=================

Connected

select version()

Connected

show variables like '%character%'

Connected

SET NAMES ujis

show databases

Connected

SET NAMES ujis

use `test`

Connected

SET NAMES ujis

SET FOREIGN_KEY_CHECKS=0

Connected

SET NAMES ujis

drop table if exists `test`.`TestTest`

Connected

SET NAMES ujis

CREATE TABLE `TestTest` (

`id` int(11) NOT NULL auto_increment,

`name` varchar(100) NOT NULL default '',

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=ujis

Connected

SET NAMES ujis

insert into `TestTest` values ('1', 'ujisORIGINAL_KANJIujis' );insert into `TestTest` values ('2', 'ORIGINAL_KANJI' );insert into `TestTest` values ('10', 'ORIGINAL_KANJI' );insert into `TestTest` values ('4', 'ORIGINAL_KANJI' );insert into `TestTest` values ('5', 'ORIGINAL_KANJI' );insert into `TestTest` values ('6', 'ORIGINAL_KANJI' )

Connected

SET NAMES ujis

SET FOREIGN_KEY_CHECKS=1

=================

Thank you for reading!

🙂

[sdozono]

What about if you change

“user_id“ “user_contact“

to

`user_id` `user_contact`

?

[sdozono]

And one more,

in the function ProcessQuery(),

I added..

> $tmp_query = “SET NAMES UJIS “;

> $tmp_res = mysql_query($tmp_query);

mysql_select_db ( str_replace ( '`', '', $db ), $mysql );

I'm using UJIS(EUC-JP) environment…

I hope this information is helpful for next version….

[sdozono]

This is just an information…

The oldest? and most famous Character Convert Program

nkf (network Kanji Filter, C)

Perl source

Perl source – jcode.pl official Website

[sdozono]

– How to configure MySQL for Japanese?

If you just need to store the Japanese data (no sorting, no SQL operation using 'LIKE'.. ), you don't need to configure my.ini or my.cnf. (“character_set latin1 ” is OK.)

if you need specific configuration,

see

Tomita Masahiro's page(Autor of Japanese patch, English)

His detailed explanation(Machine Translation Via Excite.co.jp)

– How to display Japanese in Windows when your default language is English?

I'm not sure whether English Windows(And IE or FireFox) can display Japanese Characters without installing any softwares. But my IE6 in Japanese Windows XP can display Chinese, Korean or Thai …. without installing any fonts or software.

If you want to write (input ) Japanese Characters, you can make use of

Global IME you can download freely from Microsoft.

– CREATE TABLE SQL for a sample table

See the attached “test.sql”. I stored Japanese Numbers(1234567890 in large letters) and Days of the week in three encodings. (UJIS, SJIS, UTF-8).

The image is:

[img]http://hp.vector.co.jp/authors/VA035840/temp/code_test2.PNG[/img]

SQLyog's display:

[img]http://hp.vector.co.jp/authors/VA035840/temp/SQLyog.PNG[/img]

If SQLyog has an “encoding feature” similar to IE (for example), then it will be great!

(Is RichText Control suitable?)

[Author]

Posts