> Von: [email protected] [mailto:[EMAIL PROTECTED] Im > Auftrag von Wetterman, Christopher > Gesendet: Montag, 21. Mai 2007 22:57 > An: [email protected] > Betreff: [Trac] Re: AW: [Trac] Issues Regarding Windows Install of Trac > 0.10.4 Environment > > > Trac can connect to the MySQL DB just fine. It has created all the > tables itself. I did notice though the character set is > latin1_swedish_ci for each table. Both prior and after I ran the query > ALTER DATABASE DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci, but > it still is at latin1_swedish_ci. Not sure where to go from here. > > Chris
I think that the > ALTER DATABASE DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; statement should be executed before any tables are created. You have set the default character set now and this influences only future databases/tables. If the statement is executed after the database/table creation, each database, table and field must be converted separately into UTF8. I would try the following: Create a new database for testing. As the default character set is already utf8, there should be no future conversions. Run again the trac-admin --initenv command against the new created database Add the configuration settings for the new Trac project to the Apache configuration Connect to the new Trac project which should work now. Alex --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~----------~----~----~----~------~----~------~--~---
