April 17, 2002 at 10:39 am
Does anyone know if it is possible to change the sort order of a SQL 7 database. if so, how?
We are havng problems with a clients database, and have discovered that the sort order is incorrect. Now I want to change the sort order on their database, but I can't seem to find any way except for exporting the databases, rebuilding the master database, recreating the databases, and importing the data back. Is there another way?
Many thanks.
April 17, 2002 at 10:50 am
What do you mean "sort order in database"? You not supposed to care how records are stored in the tables, just when you retrieve them - use the "order by " with indication which column you want to sort.
April 17, 2002 at 11:15 am
No other way, you hit it on the head.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 18, 2002 at 3:04 am
It's not that I'm having probems with queries, it's problems with an application using the database.
The application only has this problem when running on this particular server, and the difference would seem to be that the sort order is different on the problem server to al the other servers. I guess that there isn't any other way to change it, so might have to look into changing the application.
Thanks for taking an interest,
Jon
April 18, 2002 at 4:30 am
What is the problem the app is having? I have never seen an app freak based on sort order before as that effects that methodology for the sort to work and should not cause issues. Unless the program expects a specific order and is hard programmed that way but that would be odd.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 19, 2002 at 3:32 am
Have now discovered that it is actually the Character Sets and not specifically the sort order.
Our app is doing "update where all", and the characters it posts in string fields are different when they are read back again.
Is there anyway way to change the character sets?
April 19, 2002 at 6:04 am
You need to do a reinstall to get that properly done.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 19, 2002 at 6:06 am
Thanks.
April 19, 2002 at 6:06 am
Thanks.
April 23, 2002 at 3:22 am
You don`t need to reinstal, well, as close as dammnit. You need to remove your user databases, get all the data out, then use a util called Rebuildm.exe which rebuilds the master database with the new sort order. You then gotta rebuild your databases and reload the data. Theres a technote in Books online explaining it. It`s a time consuming process though!!
Andy.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply