nicht angemeldet
Ja, MySQL 3.23.55-nt . Wie kann ich die Spracheinstellung ändern? Kann ich das mit einer SQL-Anweisung aus dem PHP-Script machen?
In der Dokumentation zu deiner Version hab ich dies gefunden:
(Abschnitt: MySQL Localisation and International Usage)
To get German sorting order, you should start mysqld with --default-character-set=latin1_de.
Und dies (Abschnitt: SET Syntax):
SET [GLOBAL | SESSION] sql_variable=expression
Sowie:
Here follows a description of the variables that uses a the variables that uses a non-standard SET syntax and some of the other variables. [...]
CHARACTER SET character_set_name | DEFAULT
This maps all strings from and to the client with the given mapping. Currently the only option for character_set_name is cp1251_koi8, but you can easily add new mappings by editing the `sql/convert.cc' file in the MySQL source distribution. The default mapping can be restored by using a character_set_name value of DEFAULT. Note that the syntax for setting the CHARACTER SET option differs from the syntax for setting the other options.