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

How To Set Table/field Level Character Sets?

forums forums SQLyog Using SQLyog How To Set Table/field Level Character Sets?

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • #9700
      Endre
      Member

      Hello

      On mysql 5.0.19, altrough the server is started with latin2 charset, newly created varchar field has latin1 one. How can I set the table/field's charset & collation order when I create them (or later) ?

      Thanks

      Endre

    • #21696
      peterlaursen
      Participant

      With SQLyog 5.1.x there is an option to set default charset/collation for each column In CREATE TABLE and ALTER TABLE GUI's. Which version do you use? There is no GUI facility to set charset for databases and tables. I think that should be priority now … And not hidden away behind some 'advanced' button … Actually this is a basic and not an advanced option. I even think they start understand that in Bangalore … 😛

      with tables you can execute

      ALTER TABLE … default charset …….

      .. but does not change existing columns!

      With databases you can

      CREATE DATABASE … default charset …. or

      ALTER DATABASE … default charset ….

      … but again ALTER the default does no change existing data. has effect with new tables only.

      If you have data using a 'wrong' charset you can export them and edit the backup file or copy data to another database/table created in advance with the 'right' charset.

      “On mysql 5.0.19, altrough the server is started with latin2 charset, newly created varchar field has latin1 one.” Then the DATABASE or the TABLE must have another default than the server. What does the SQLyog OBJECTS tab tell in the 'create statement' for the table?

Viewing 1 reply thread
  • You must be logged in to reply to this topic.