Re: sort order
From: Hung Le (HungLe_at_discussions.microsoft.com)
Date: 02/15/05
- Next message: Steve Thompson: "Re: Joining Domain"
- Previous message: Geoff N. Hiten: "Re: SQL2KE, SP3a cluster install"
- In reply to: Mike Epprecht \(SQL MVP\): "Re: sort order"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 15 Feb 2005 07:57:06 -0800
Thanks Mike I tried your suggestion but the result from the query doesn't not
return proper order '~~~~' still before 'AAAAA'
Regards
"Mike Epprecht (SQL MVP)" wrote:
> Hi
>
> Do you have an ORDER BY clause. If not, you are just lucky that in SQL
> Server the records are coming back the way you expect them to.
> If you do not specify an ORDER BY clause in your query, you may get results
> back in any sequence.
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> IM: mike@epprecht.net
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
> "Hung Le" <HungLe@discussions.microsoft.com> wrote in message
> news:06110779-641B-4118-AC10-A1D8234FCA59@microsoft.com...
> > I have a column in table (primary key) which has 2 rows:
> > 'AAAA'
> > '~~~' in MMSQL 7.0 when i use select * from the table 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 ?
> >
> > Thanks
> >
> > Hungle
> >
> >
>
>
>
- Next message: Steve Thompson: "Re: Joining Domain"
- Previous message: Geoff N. Hiten: "Re: SQL2KE, SP3a cluster install"
- In reply to: Mike Epprecht \(SQL MVP\): "Re: sort order"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
