Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 17 total)
  • Author
    Posts
  • in reply to: Sqlyogtunnel.php For 5.23 With Php 5.0.4 #23392
    sdozono
    Member

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

    Thank you very much!

    🙂

    in reply to: Boosted Two-way Sync (more Than Mysql Cluster?) #22696
    sdozono
    Member
    in reply to: Varchar-a Space At The Top Of Data #19449
    sdozono
    Member

    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.

    in reply to: Export Data As Sql Statements – No Line Feed #19438
    sdozono
    Member

    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]

    in reply to: Varchar-a Space At The Top Of Data #19444
    sdozono
    Member

    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…');

    in reply to: Varchar-a Space At The Top Of Data #19443
    sdozono
    Member
    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!

    🙁

    in reply to: 4.2 Beta3 Sync – Unsuccessful.. #19394
    sdozono
    Member

    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. 😆

    in reply to: 4.2 Beta3 Sync – Unsuccessful.. #19391
    sdozono
    Member

    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!

    in reply to: 4.2 Beta3 Sync – Unsuccessful.. #19387
    sdozono
    Member

    Additional Info.

    version()

    4.1.12

    [FedoraCore 4]

    version()

    4.1.7-nt

    [Windows XP]

    version( )

    4.0.22-standard

    [? ISP]

    in reply to: Feature: Charset Option For V4.2 #19003
    sdozono
    Member

    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.)

    in reply to: Feature: Charset Option For V4.2 #19000
    sdozono
    Member

    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!

    🙂

    in reply to: columns all=no don't work #18741
    sdozono
    Member

    What about if you change

    “user_id“ “user_contact“

    to

    `user_id` `user_contact`

    ?

    in reply to: Bug:MYSQL 4.0 -> 4.1 Sync on 2byte environment #18737
    sdozono
    Member

    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….

    in reply to: Character encoding Feature #17972
    sdozono
    Member

    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

    in reply to: Character encoding Feature #17971
    sdozono
    Member

    – 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?)

Viewing 15 posts - 1 through 15 (of 17 total)