Forum Replies Created
-
AuthorPosts
-
sdozonoMember
I have used SQLyog 5.23rc3 and it works nicely with SQLyogtunnel.
Thank you very much!
🙂
sdozonoMemberI 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
sdozonoMemberpeterlaursen:
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.
sdozonoMemberYes. 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]
sdozonoMemberCan 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…');
sdozonoMemberpeterlaursen 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!
🙁
sdozonoMemberOk. 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. 😆
sdozonoMemberI 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!
sdozonoMemberAdditional Info.
version()
4.1.12
[FedoraCore 4]
version()
4.1.7-nt
[Windows XP]
version( )
4.0.22-standard
[? ISP]
sdozonoMemberTo 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.)
sdozonoMemberSorry, 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!
🙂
sdozonoMemberWhat about if you change
“user_id“ “user_contact“ to
`user_id` `user_contact` ?
sdozonoMemberAnd 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….
sdozonoMemberThis is just an information…
The oldest? and most famous Character Convert Program
Perl source
sdozonoMember– 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?)
-
AuthorPosts