| Posted: 14 Nov 2005 12:30 | |
|
Registered User Currently Offline |
Posts: 1 Join Date: Nov 2005 |
|
Hi!
I am using WAMP as a local mirror and testing platform for changes on my actual web server. Sometimes I want to synchronise database contents from the online DB to the local one in a one-way fashion, i.e. I delete the local DB and import everything from scratch via SQL statements created by phpMyAdmin on the server. I just copy and paste the SQL statements to the local WAMP server and execute them. The import always runs smoothly, but my tables' collation is always set to latin1_swedish_ci. This collation value seems to be a default, as it does not occur anywhere in the SQL statements. How can I change the collation default to German instead of Swedish? |
|
| Posted: 27 Nov 2005 20:57 | |
|
Administrator |
Posts: 125 Join Date: Feb 2005 |
| This seems like a MySql-specific question. Did you check the MySql manual for an answer? | |