distal-attribute
distal-attribute
distal-attribute
distal-attribute

Default collation

User, date Message
Written by skuja
5 years ago
Category: Feature discussion
12 posts since Thu, 05 Nov 09
When i am creating a new db or table the default charset is set to latin1 and default collation latin1_german_ci, is there a way to set my favorite default charset?
Written by ansgar
5 years ago
5018 posts since Fri, 07 Apr 06
Yes, by editing the my.cnf / my.ini on the server you can set the global default collation, just can't remember the name of that ini section.

If you need that for one database and it's tables only, you can edit the database and specify the collation, which will then be the default for new tables you create afterwards.
Written by skuja
5 years ago
12 posts since Thu, 05 Nov 09
hmm.. i created new database with utf-8 charset, but still for all the new tables the default is utg-8.
It would be very handy option that you could set default charset, that would be independent of mysql configuration, somewhere in application settings, in further releases.
Written by ansgar
5 years ago
5018 posts since Fri, 07 Apr 06
That would make many users wonder.

skuja wrote: i created new database with utf-8 charset, but still for all the new tables the default is utg-8.



utg-8 ? I guess you mean utf-8 in which case that would be perfectly what you want, is it?
Written by skuja
5 years ago
12 posts since Thu, 05 Nov 09
oh i am sorry! I meant that i set database charset to utf-8, but default charset for new tables is latin.
Written by ansgar
5 years ago
5018 posts since Fri, 07 Apr 06
Cannot reproduce that here. In a utf8_general_ci collation'ed database I started to create a table which by default had exactly the same collation. Of course using the latest nightly build - which revision are you using?
Written by skuja
5 years ago
12 posts since Thu, 05 Nov 09
Version 4.0, revision 2405
Written by skuja
5 years ago
12 posts since Thu, 05 Nov 09
I updated .exe file to the latest revision and it all works as should.
Thanks for your help and keep up the good work!
 

Please login to leave a reply, or register at first.