I have a column in table (primary key) which has 2 rows: 'AAAA'
'~~~' in MMSQL 7.0 when i use select * from the table order by .... the
query result will be
'AAAA'
'~~~~'
but when I converted the database to SQL 2000 the result will return
'~~~~'
'AAAAA'.
I tried to change collations and sort order but no luck.
in SQL 7.0 when I type in sp_helpsort the Query return:
Character set = 1, iso_1
ISO 8859-1(Latin01) - Western European 8 - bit
character set.
Sort Order = 50, bin_ISO 8859-1 (Latin 1) character set characters, in order
Can anyone tell me how to correct the problem ?
Re: complex filter and calculations in access ... switch to SQL view. ...query by switching to datasheet view, ... of your database using the from address in this post. ...pre-op infections yes/no ... (microsoft.public.access.queries)
Re: A little more meat this week ... implementation with a query processor capable of returning a result set ... then we can call it a result bag (SQL... I'm looking at the data model and not database tools at this ... for a s/w developer and a s/w developer simplifies for the end user). ... (comp.databases.pick)
Re: complex filter and calculations in access ... when using a subquery on the same table as the main query, ...switch to SQL view. ... of your database using the from address in this post. ... (microsoft.public.access.queries)
Re: A little more meat this week ... said data includes lists."... implementation with a query processor capable of returning a result set ... then we can call it a result bag (SQL... I'm looking at the data model and not database tools at this ... (comp.databases.pick)
Re: Very slow query ... indexed for all the secondary tables, only the primary key is indexed). ... create a new blank database and immediately turn OFF the Name ... With 14 secondary tables or less, my query runs in 1 sec or less. ... in forms, base the form on the primary data table, and use combobox or ... (microsoft.public.access.queries)
