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

Forum Replies Created

Viewing 1 post (of 1 total)
  • Author
    Posts
  • in reply to: How Can I Alter The Charset Of A Db Or Table? #23108
    BusterK
    Member
    peterlaursen wrote on Dec 20 2006, 05:32 AM:
    We do not yet provide such option from the GUI.

    You can use SQL like 

    “CREATE DATABASE DEFAULT CHARSET cp850”

    “CREATE/ALTER TABLE tablename DEFAULT CHARSET cp850”

    (and the charset for the databae and/or table will be different from the server default.

    You can change the server defa

    But two things you should note:

    1)  This will only have effect on NEW databases and tables.

    2)  After that when connecting with SQLyog choose 'cp850' for the connection and not '

    default'  

    Many thanks peterlaursen.

    But you were saying “You can change the server defa…”, is it how to change the server default charset?

    Please explain me that.

Viewing 1 post (of 1 total)