PROTECTED]>
Subject: ORDER BY sorting
Hello,
I'm trying to figure out how sort a column alphabetically, but some of the
values start with a numerical value. So when I do the ORDER BY column_name
all
the values starting alphabeticlly are listed first, then the numerical
values
after that.. can
Hello,
I'm trying to figure out how sort a column alphabetically, but some of the
values start with a numerical value. So when I do the ORDER BY column_name all
the values starting alphabeticlly are listed first, then the numerical values
after that.. can this be done in a single query..
MySQL
Webmaster33,
Thursday, April 18, 2002, 8:01:30 PM, you wrote:
W> I understand. Bad to hear. :-(
W> I think there would be important to implement features to be able
W> to set different character sets for each table, or to change
W> character sets dynamically without the need to restart MySQL
I understand. Bad to hear. :-(
I think there would be important to implement features to be able
to set different character sets for each table, or to change
character sets dynamically without the need to restart MySQL server.
This would be especially important for the ORDER BY string
collations
Webmaster33,
Wednesday, April 17, 2002, 7:21:55 PM, you wrote:
W> Anybody knows how can I change the character set, when MySQL is running,
W> to be able to do ORDER BY using international strings?
W> I would need to do this without changing config, while I run my perl script.
W> I would need to
Hi!
Anybody knows how can I change the character set, when MySQL is running,
to be able to do ORDER BY using international strings?
I would need to do this without changing config, while I run my perl script.
I would need to do sortings for different languages. So locale definition
should be cha
