Navigation
Greetings, my name is Fehér János, my nick is Aries. I'm a Hungarian IT professional I spend 12 hours a day with my profession. I want to spend more time with my Love, friends, reading, biking, playing on my bass again, but it's a spined off world, we have no time for to live our life.
Recent blog posts
User login
Poll
Am I suxx if the blog's language is English?
Yes
58%
No
42%
Total votes: 352
Navigation
Syndicate
I've upgraded MySQL from version 4.1.9 to version 4.1.12. After this the mysql's log were full of lines such this:
050722 18:30:47 [Warning] './dbname/counter' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
050722 18:30:47 [Warning] './dbname/banners' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
...
So, I have to use ALTER DATABASE:
ALTER DATABASE `dbname` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
The upgrade script should be more intelligent.
Thanks!
Thanks for the hint. Helped me solve my problem...see "brusselsshrek" post on:
http://dev.mysql.com/doc/mysql/en/charset-table.html
You're welcome
You're welcome :)
--
Fehér János aka Aries
Post new comment