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

character_set_client

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › character_set_client

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • November 25, 2004 at 1:35 pm #8667
      Anonymous
      Guest

      SQLyog 4.0 does not set character_set_client, character_set_connection and character_set_results variables in accordance with the connected mysql server's settings. Therefore, simple queries involving character comparisons fail with the infamous “invalid collation …” messages. To overcome this situation, one can set these variables manually, each time after a connection is established to the mysql server:

      set character_set_client = latin5;

      set character_set_connection = latin5;

      set character_set_results = latin5;

      Replace latin5 with your desired character set.

      Prevoius 3.71 version did not have this bug.

      Regards,

      Gokhan Demir

    • November 25, 2004 at 1:46 pm #16591
      Ritesh
      Member

      It is because we are now using a new client library.

      We are working on this issue and plan to fix it in 4.1.

    • December 15, 2004 at 3:40 pm #16592
      laurince
      Member
      Ritesh wrote on Nov 25 2004, 01:46 PM:
      It is because we are now using a new client library.

      We are working on this issue and plan to fix it in 4.1.

      Expecting for that!

      My server & encoding are mysql-win32-5.0.2-alpha, utf-8,

      Chinese characters (sure stored properly) are displayed as “???” in the client,

      I suggest that the connection has a property charset_client/…

      which is customizable to specify our own encoding.

      Regards

      Roger

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.