Hi you have to restart your mysqld server with --default-character-set=greek option. You can either do this by explicitly giving it in the command line when restarting your mysqld, or you can add that line to your global my.cnf file. See: http://www.mysql.com/doc/en/Command-line_options.html and http://www.mysql.com/doc/en/Option_files.html
Hope this helps Gurhan On Wed, 2002-09-04 at 03:29, Achilleas Maroulis wrote: > Hi, I have a MySQL problem but due to small problem of my email I can't subscribe to >a MySQL list so I wonder if someone from you can answer (actually I'm sure about >it...) > My problem is that I have a query that fetches all data from a table in alphabetical >order using the "...order by col_name asc..." command. The problem is that the data >in this column is not in english but in greek (as I am Greek!!) and they are not >coming in the right order. > I don't know where to start searching for the solution... > Is it the operating sysytem (SuSE LINUX 8.0 in greek) or the MySQL installation >(v3.23 which came with the SuSE installation)? > > Thanx in advance... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
