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

Forum Replies Created

Viewing 15 posts - 31 through 45 (of 642 total)
1 2 3 4 … 41 42 43
  • Author
    Posts
  • May 23, 2005 at 8:46 am in reply to: SQLyog Support MySQL 5.x ? #17770
    Shadow
    Member

    Even latin1 produced interesting side effects, byte length of field A was 10, while byte length of field B was only 5 after the INSERT statement on the first screenshot had been executed…

    I guess, we won't be using MySql 5 beta for a while…

    May 23, 2005 at 8:38 am in reply to: Install option #17857
    Shadow
    Member

    I would not allow average users to get near of any SQLyog betas, but the idea is great!

    May 20, 2005 at 12:20 pm in reply to: SQLyog Support MySQL 5.x ? #17767
    Shadow
    Member

    But the most interesting results occured, when I switched to ucs2 encoding. Even the SELECT command should complete succesfully, but that USE command beats everything:

    May 20, 2005 at 12:18 pm in reply to: SQLyog Support MySQL 5.x ? #17766
    Shadow
    Member

    5, and 6 are not even released yet…

    But here comes the first of the promised screenshots. Encoding was set to utf8 (table encoding is utf8 as well), and then we try to insert a new record. Field A is of int type (autoincrement), B and C are of varchar(45).

    May 20, 2005 at 9:11 am in reply to: SQLyog Support MySQL 5.x ? #17764
    Shadow
    Member

    Upon further testing, we are not sure, that this is a bug in SQLyog, it may well be in MySql itself… I'll be posting command line screenshots later on.

    May 20, 2005 at 8:12 am in reply to: SQLyog Support MySQL 5.x ? #17763
    Shadow
    Member

    Well, it's not just the lack of GUI support for stored procs that causes inconveniance, but INSERT/UPDATE commands fail to work if they involve special characters and client side encoding is set to utf8 using SET NAMES command. Encoding of underlying db or table(s) seems to be irrelevant to this issue. If the inserted/updated string contains special characters, an emtpy string gets inserted/updated.

    This was tested with SQLyog Ent. v4.06 on W2K with MySql v5.0.3 beta, InnoDB. Special characters in question belong to Hungarian alphabet.

    May 20, 2005 at 8:05 am in reply to: Scheduled Backups – Could not connect… #17851
    Shadow
    Member

    No, I did not mean sja-sample.xml! Sja uses XML files to store sync or notification jobs. Find the corresponding XML file (if the wizard had gone that far…) of you sync!

    May 19, 2005 at 2:53 pm in reply to: Scheduled Backups – Could not connect… #17849
    Shadow
    Member

    Perhaps you could check the contents of generated XML file. SQLyog may write incorrect URL into that file.

    May 19, 2005 at 8:31 am in reply to: Synchronization using SSH tunneling #17832
    Shadow
    Member

    Try inceasing the connection timeout variables in case of the tunneled server!

    May 18, 2005 at 4:00 pm in reply to: show create table tbl_products; #17796
    Shadow
    Member

    Right-click pop-up menu and hot-keys are not sufficient?

    May 18, 2005 at 11:31 am in reply to: Relation #17830
    Shadow
    Member

    First: not all table types (now referred to as engines) support relationships! Second: there is a separate relationship manager in SQLyog (F10 is its hotkey), use that one instead of manage indexes feature.

    May 17, 2005 at 7:27 am in reply to: show create table tbl_products; #17793
    Shadow
    Member

    This is not a bug of SQLyog, but rather a bug of the GUI control SQLyog uses. It simply cannot handle line breaks… In case of SHOW CREATE TABLE command switch to Edit->Show results in text, and results will be displayed as expected. However, if you have more fields in the returned resultset, that contain line breaks, then even this workaround is spoiled.

    May 17, 2005 at 7:21 am in reply to: Lost connection to Database #17811
    Shadow
    Member

    Ping may not do Ritesh! 1. Some firewalls may be configured to drop all ICMP echo requests. 2. In case of tunneled connection, ping is not suitable either!

    I suggest to use some common SQL command, such as “USE ” or “SHOW DATABASES”.

    May 17, 2005 at 7:13 am in reply to: data to clipboard –> delims #17802
    Shadow
    Member

    As far as I can recall, SQLyog does store the settings in sqlyog.ini and this feature has long been requested. I tested on v4.06 and it works.

    May 17, 2005 at 7:09 am in reply to: Almost Cosmetic – ALTER TABLE bug #17679
    Shadow
    Member

    Just forgot to attach the screenshot, and in edit mode I can't add picture to the post…

  • Author
    Posts
Viewing 15 posts - 31 through 45 (of 642 total)
1 2 3 4 … 41 42 43