Sort access database

[lannsjo]

I have a database with swedish words but cant sort them in the correct
order. When I hit sort Ascending the swedish letters Å Ä and Ö is
not sorter correctly.
How do I change this???

[Benny Andersen]

On 14 Apr 2005 07:31:07 -0700, la*****@home.se wrote:

I have a database with swedish words but cant sort them in the correct
order. When I hit sort Ascending the swedish letters Å Ä and Ö is
not sorter correctly.
How do I change this???

(in danish)
menuline->funktioner->indstillinger->generelt->sorteringsrækkefølge

--
Benny Andersen

[lannsjo]

that didnt help! it still sorts the table like this:

Åby
Angered
Backa
Örebro
Oslo
Ystad

I want it like this:

Angered
Backa
Oslo
Ystad
Åby
Örebro

To be mentioned is that I am getting the table with an ADO recordset:
strSQL = "SELECT * FROM Adresstable ORDER BY Adress"

When I connect to the database I do it like this:
cDB.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Locale
Identifier=1053;" & "Data Source=" & server.MapPath("data.MDB")

I read that I could put the Locale Identifier=1053 (swedish/finnish)
but That didnt help either?????

Someone??
/M

[Lyle Fairfield]

la*****@home.se wrote:

When I connect to the database I do it like this:
cDB.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Locale
Identifier=1053;" & "Data Source=" & server.MapPath("data.MDB")

Did you try 1033?

[lannsjo]

Yes, but It didnt help????????????

[Lyle Fairfield]

la*****@home.se wrote in news:1113575735.155515.209280
@g14g2000cwa.googlegroups.com:

Yes, but It didnt help????????????

You could try this:

1. Make a safety copy of your table!

2. Check to be sure you have a safety copy of your table! Then be sure you
have a reference to ADO.

3. Check to be sure you have a safety copy of your table! Then run this
code:

CurrentProject.Connection.Execute "ALTER TABLE Yourtable ALTER Column
YourColumn binary"

(Remove line breaks before using.)

4. Try the sort again.

Did I mention: Make a safety copy of your table!

???

If not then be sure

TO

Make a safety copy of your table!

--
Lyle
--

[lannsjo]

ahhh.. no that cant help, what would it help to make my column
binary...??

I need to fix this problem, someone?

[Lyle Fairfield]

la*****@home.se wrote:

ahhh.. no that cant help, what would it help to make my column
binary...??

It would accomplish a binary sort, which, it seems, is what you want.

--
--
Lyle
--

[Albert Marshall]

Lyle wrote

la*****@home.se wrote:

ahhh.. no that cant help, what would it help to make my column
binary...??

It would accomplish a binary sort, which, it seems, is what you want.

Assuming that I understand what's going on (always a problem, that) then
how about creating a function that loops through a string and converts
all its characters to their ASCII equivalents. Then you could sort on a
query using that function in a calculated field.

Don't laugh, I actually had to do this once, but it's slow.

I'm going to go away and have a play with this. Wish me luck.
--
Albert Marshall
Marshall Le Botmel Ltd
01242 222017

[Lyle Fairfield]

Albert Marshall wrote:

Lyle wrote

la*****@home.se wrote:

ahhh.. no that cant help, what would it help to make my column
binary...??

It would accomplish a binary sort, which, it seems, is what you want.

Assuming that I understand what's going on (always a problem, that) then
how about creating a function that loops through a string and converts
all its characters to their ASCII equivalents. Then you could sort on a
query using that function in a calculated field.

Don't laugh, I actually had to do this once, but it's slow.

C'mon Albert, admit it. It was your grandfather, right? And it just
finished yesterday....

--
--
Lyle

[Douglas J. Steele]

Can't say for certain, as I haven't tested, but
http://msdn.microsoft.com/library/en...etprovspec.asp
seems to imply that the Connection should have a property named
DBPROP_INIT_LCID that you should be able to set.

See whether

cDB.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" &
server.MapPath("data.MDB")
cDB.Properties("DBPROP_INIT_LCID") = 1054

works.

On the other hand, section 5.1 of http://www.winsoft.sk/adofaq.htm suggests:

cDB.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Locale
Identifier=0x041d;" & "Data Source=" & server.MapPath("data.MDB")

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

<la*****@home.se> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
that didnt help! it still sorts the table like this:

Åby
Angered
Backa
Örebro
Oslo
Ystad

I want it like this:

Angered
Backa
Oslo
Ystad
Åby
Örebro

To be mentioned is that I am getting the table with an ADO recordset:
strSQL = "SELECT * FROM Adresstable ORDER BY Adress"

When I connect to the database I do it like this:
cDB.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Locale
Identifier=1053;" & "Data Source=" & server.MapPath("data.MDB")

I read that I could put the Locale Identifier=1053 (swedish/finnish)
but That didnt help either?????

Someone??
/M

[lannsjo]

Thanks everyone for your help, but nothing helped...
I finally found the problem, the database must have been corrupt. I
transfered all database tables to a new database and everything worked
fine..

Things like this really makes you mad...

Another question:
Where are the good reference guides for asp on the net.. I have been
searching for months now. PHP.net and mysql's reference guides are so
much better...