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

4.1 Encoding Problems

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › 4.1 Encoding Problems

  • This topic is empty.
Viewing 5 reply threads
  • Author
    Posts
    • September 27, 2005 at 8:53 am #9256
      PvUtrix
      Member

      When I change the encoding from the default in MySQL 4.1 to let's say cp1251, I have to run a query “SET names cp1251” to see the data properly in web pages. In SQLyog however this does not work and all encoded data is retured as question marks.

      phpMyAdmin properly shows all the data…

      Will automatic encoding support be implemented? or is there a way to set the encoding for a certain connection?

    • September 27, 2005 at 9:28 am #19303
      peterlaursen
      Participant

      see Shdows' comment at the end.

      http://www.webyog.com/forums/index.php?showtopic=1402

      did that do the trick.

      “encoding” is not a word in MySQL terminology. It's purely a browser terminology.

    • September 27, 2005 at 9:31 am #19304
      peterlaursen
      Participant

      From MySQL doc's

      http://dev.mysql.com/doc/mysql/en/charset-connection.html

    • September 27, 2005 at 9:54 am #19305
      peterlaursen
      Participant

      When I start a new connection to MySQL 5.1 with SQLyog 4.2 beta2, RESULT tab shows:

      show variables like '%character%'

      Set character_set_connection=latin1

      Set character_set_results=latin1

      Set character_set_client=latin1

      *****************************************************


      @ritesh      : some questions

      1) I guess these values are the default server settings?

      (fetch by the 'show variables' statement.

      2) shouldn't it do this too:

      SET collation_connection = @@collation_database

      3) what pvutrix request is actual a tab more in connections manager with that sorts of settings. In case user has specified these parameters, they shall be used and “show variables like '%character%'” shall not be sent. Actually in an international environment I think it is quite important to be able to operate smoothly in more 'locales'. Comment ?

    • September 27, 2005 at 10:13 am #19306
      peterlaursen
      Participant

      YES !!

      I propose that 4.3 will have a TAB more in connections manager named “locale settings”, with three possible choices.

      1) use server default

      2) use database default (will query locale settings from first database specified in “server” TAB

      3) manual settings

      It would be appropriate to introduce that with 4.3 (with Unicode support).

      Maybe there are other connection-specific settings than local's that are relevant ?

      check from http://dev.mysql.com/doc/mysql/en/server-sql-mode.html .

      Those “modes” can from MySQL 4.1 be operated independently by each connection/client

    • September 27, 2005 at 11:34 am #19307
      Ritesh
      Member

      As you know, we plan to completely overhaul the language issues in v4.3. This proposal is already in the plan for v4.3 where a user can actually specify the collation to be used.

      With v4.3, issues similar to PvUtrix's will be fixed 🙂

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