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?
