Problem with Order by in French

From: Carl Shamie <carls_at_videotron.ca>
Date: Tue, 4 Jan 2000 21:14:03 -0500
Message-ID: <BKxc4.1602$Bu1.53052@wagner.videotron.net>

Hello,

We are currently working on designing and using an Oracle 8.0i database for an e-commerce web site. We are having a small glitch! When we use the ORDER BY function we never get a good sorting of the names. Here is an example of the problem.

    AB
    af
    Épicerie
    TEST
    #Test
    tintin
    4u all

Now as you see the numbers are at the end : That`s correct. Why is the pound sign between two "T". Does Oracle drop the first character? We have done the following settings :

alter session set nls_language = french; alter session set nls_sort = french;

Why do we need french? Cause the site must be bilingual and french has a lot of accents on letters which are not sorted right without these settings!

Can anybody help us on this one? Is there a setting that we overlooked?

Thank you

Carl S.
Java/Web developper Received on Tue Jan 04 2000 - 20:14:03 CST