dcsimg
How can I change the assortment with "ORDER BY"?
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Jana_L
Posted On:   Wednesday, June 25, 2003 12:36 AM

My problem:

			
SELECT NAME FROM KUNDE ORDER BY NAME;



The result on a Windows system looks in such a way: A, B, C, ... Z (large and lower case one does not consider).



The result on a Unix system looks in such a way: A, B, C, ... Z, a, b, ...



Now I need an assortment, which does not differentiate between large and small letters on the Unix system (as under Windows).




Thanks
Jana

Re: How can I change the assortment with "ORDER BY"?

Posted By:   Simon_Ablett  
Posted On:   Wednesday, June 25, 2003 01:54 AM

This is a factor of your database and not of your operating system. I assume that you are using different database systems on each; or at least different implementations of the same (?).

Regards.
About | Sitemap | Contact