How To Create Character Like æ, ø, å

[sommerjack]

I have downloaded SQLyog v.5.19, but I have problem to type in the Danishs letters æ, ø, å.

I.e. I want to type in some data to a mediumText and tried the following collations:

utf8_generel_ci

utf8_danish_ci

latin_danish_ci

…..

But the characters are not shown correct. Either they are missing, either they are replaced by '?'.

Can anyone help?

[peterlaursen]

From where did you get 5.19? We don't support old versions like that. Only in very special situations we aske users to test an issue with it. Please try version 6.05! This one maeks it much easier!

This is NOT AT ALL related to collations. All characters are the same in every latin1 (or utf8) collation!

collation only defines such things as sorting order.

Do you use a Danish keyboard when you enter?

Is your computer running Danish locale setting?

If they are not show correct, how are they shown then?

Why don't you attach a screendump so that we can see?

In 5.19 there is a charset collector in the connections screen. What do you select here and what is server default charset?

I can add that I have been using SQLyog since an early 3.x with Danish without problems!

[sommerjack]

peterlaursen wrote on Aug 8 2007, 11:29 AM:

In 5.19 there is a charset collector in the connections screen. What do you select here and what is server default charset?

Thanks for your support and questions 🙂 Now it works.

I didn´t realized until now that there was a charset collector in the connections screen… Now I changed this to Latin1 and it works now.

Another thing is that when I save a new table it is automatically stored with table type InnoDB. How can I change the settings so it will be saved as a myISAM?

[peterlaursen]

A table will be created with the database default unless you specify something else! And database will be same as server default unless you specify something else when creating the database!

You can change server default in the my.ini/my.cnf file.

I am not quite sure if you can change default for existing databases otherwise than dumping it, editing the SQL file and importing again. But I do not think so!

[Author]

Posts