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

Forum Replies Created

Viewing 15 posts - 3,286 through 3,300 (of 7,398 total)
  • Author
    Posts
  • in reply to: #25768
    peterlaursen
    Participant

    @Fuzzy

    1) are you using SSH-tunnel or not?

    2) commenting your coding considerations will have to wait till Monday!

    in reply to: #25825
    peterlaursen
    Participant

    This is a reasonable request.

    We will add this formatting issue to the TODO for version 6.2.

    in reply to: #25828
    peterlaursen
    Participant

    Don't you think that every user using this feature would have his own needs and wishes?

    Do you have any implementation idea?

    Should user build a CSS in advance and SQLyog should use it?

    in reply to: #25824
    peterlaursen
    Participant

    On 2K/XP you will need to enable

    * far-eastern languages (CJK)

    * so-called 'complex languages' (Thai, Indian languages)

    You do so from control panel .. regional settings (I do not remember the XP control panel more in detail now – but you will easily find it).

    Maybe that will update the font with a more complete one?

    Did you enable those languages in the system?

    On XP those languages are not enabled by default. On Vista they always are enabled (Vista is not critical about diskspace used!).

    However I think that the Arial fonts maybe always are complete on XP too for webpage display of pages with those langiages.

    I definitely can display all those languages on this Vista system and my old XP system (after installing support for all languages in XP of course!)

    in reply to: #25821
    peterlaursen
    Participant

    “Courier New cannot display utf8 characters so I just realized.”

    The Courier New font that I have in my current Vista system as well as the one I had in my old XP system could.

    Is this a issue with the font distributed with Win 2K maybe? Also Win 2K has known font rendering issues! What is your OS?

    See attached image for the properties of my font file! It is a VERY BIG unicode OpenType (that means a combined TrueType and Postscript) font. File version is 5.00. It has glyphs for losts of languages! It came with my current Vista system!

    [attachment=820:cour.gif]

    We use this font primarily because it is a non-proportional font.

    I also think from your description that you are using SQLyog 5.x? The dropdown for charset selection in Connections Manger is not in 6.x because it is not required anymore. Also 5.x versions are not supported any more! But my font file works with SQLyog 5.x too!

    Related FAQs here: http://webyog.com/faq/category/34/characte…ion-issues.html

    and this one in particular: http://webyog.com/faq/content/34/148/en/do…y-language.html (the basics of character set handling in SQLyog is explained here)

    in reply to: #25810
    peterlaursen
    Participant

    I think that installing the MS core fonts in Wine may give other result than installing in the underlying Linux system!

    basically I think this can be 2 (very different, actually) issues.

    1) byte/octet stream from the server is Chinese utf8. That was what I first thought (because the Chinese looked genuine), but now I am not sure!

    2) the fonts mapping between Wine and Linux kernel fails with this particular configuration!

    in reply to: #25819
    peterlaursen
    Participant

    All files except supported image files will display as characters in the BLOB viewer (and sometimes as 'garbage' character sequences. That is not only Office data, but also multimedia data (like mp3, wav etc.) and executables (.exe, .dll) etc.). Word cannot access a BLOB stored in a MySQL database and also not a BLOB displaying in SQLyog BLOB viewer. Word can access the Windows File System only. A word file requires the Word program (or a compatible program) to display.

    Anyway you may store a Word document and after saving to the File System again Word can handle it. Use a BLOB and not a TEXT!

    There are no plans of supporting display of Word documents in SQLyog. Word data are 'closed source' (though it would probably be possible by using Open Office or K-Office open-source code to display it).

    A HEX-editor like display of binary data is 1st priority enhancement for the BLOB viewer.

    in reply to: #25815
    peterlaursen
    Participant

    1)

    I was doing live editing in the table content – at the bottom. When i click on another row it auto saves changes – so it's an insert not update!!

    >>> can you help describing how to reproduce this consistently?

    2)

    I suggest you really add that LIMIT 1 feature

    >>> I think we should consider that option in the warning popup .. like an option to “delete number of rows”

    I do not think it is a bug. But with a Grid/GUI interface you can be right that users would expect a row to be identified uniquely if they do not think about the underlying SQL.

    in reply to: #25813
    peterlaursen
    Participant

    please read this FAQ:

    http://webyog.com/faq/content/28/70/en/i-o…tabase-why.html

    DELETE FROM .. WHERE … will delete all rows that satisfy the WHERE condition.

    (the FAQ deals with UPDATES, but exactly the same issue with DELETES)

    Maybe phpMyAdmin adds a 'LIMIT 1' to the statement. We don't. We advise users to have a PK! This is both safer and more efficient.

    Please detail this

    “I also noticed that in the same table (with no PK) it will sometimes insert 2 identical rows when only 1 should have been added”

    Are you INSERTING or UPDATING ??? It ishould not happen if inserting. Please check the HISTORY tab what SQLyog sends to the server?

    in reply to: #25808
    peterlaursen
    Participant

    Please:

    1) check tools .. preferences .. editor.

    What is the font selected for 'others'. Could you experiment with a few others?

    2) could you try install the MS core fonts in Wine.

    Please refer to: http://webyog.com/faq/content/31/71/en/can…r-on-linux.html

    (download link is there)

    3) we would like to know if data in RESULT tab also become chinese if you 'show result in text'

    4) finally:

    what is your LOCALE setting?

    if non-US could you change the LOCALE in a console and start SQLyog from that console?

    in reply to: #25806
    peterlaursen
    Participant

    Two more question actually for you!

    1)

    Is it only *error* messages that display in chinese?

    What about *no error* mesages (like '37 rows affected')?

    2)

    Am I correct in assuming that the MySQL server is 64 bit?

    in reply to: #25805
    peterlaursen
    Participant

    Maybe it isnt worth your effort to look too much into this.

    >> We would hate if at least we don't understand it!

    The bug might just as well be inside Wine somewhere.

    >> Actually what I thought too. It also may be related to running 32 bit software like Wine on a 64 bit platform.

    Perhaps some win32 widechar-stringhandling function in either libmysql (do you link statically with libmysql.lib or use other mysql-client?) or sqlyog.exe works incorrect in current wine version? (just speculating)

    >> SQLyog is a windows program. So we use libmysql.dll. Whether we 'link' or 'include' or whatever I do not know!

    if an newer version of Wine resolves this issue I'll post here to let you know.

    >> Much appreciated!

    Also I am wondering why it affects error messages only and not data returned from queries!

    We will discuss how to proceed with this!

    in reply to: #25803
    peterlaursen
    Participant

    Ok .. thanks for the feedback.

    Then we will have to look detailed into it. It may take a little time because I think we will need to 'establish' a setup with identical Linux distro, Wine and MySQL versions.

    Please tell if the Wine and MySQL versions were installed with Linux or if you have updated those from another source!

    Please also try to connect and execute ” SHOW VARIABLES LIKE '%character%'; “

    .. and paste the result here.

    I would also like to see your my.cnf file!

    Please confirn too that you were connected to the same server with all those clients? This is important!

    This is very weird to me how this can happen. With UTF8 such charset 'mess-ups' should be prevented by the encoding itself – it has no 'endianness' and the byte patterns that could mess up like this *should* be impossible! With UCS2 'mismatching' with multibyte non-unicode encodings (such as 'Big5') is theoretically possible!

    in reply to: #25801
    peterlaursen
    Participant

    My mistake then. I must have confused something. But it took very long time to retrieve that picture last night.

    Anyway .. did you try an erroneous message with another client like command-line?

    in reply to: #25796
    peterlaursen
    Participant

    We do plan more 'microscopic' options to the STRUCTURE SYNC tool.

    We had similar requests for copying individual Stored procedures, Views etc. Not sure we had for table columns before.

    We will need a little time to discuss.

    Do you use ENTERPRISE version that includes STRUCTURE SYNC?

Viewing 15 posts - 3,286 through 3,300 (of 7,398 total)