By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,128 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

incorrect OREDR BY results when reading from access DB using fields in different charset

P: n/a
Or
I have an access database full with data written in hebrew charecters.
any query which uses a hebrew charecter field for the ORDER BY clause
is not sorted properly.
The database is sitting in a hosting company server and is the standard
english version.
The data is entered over the internet from hebrew enabled computers.

Nov 17 '05 #1
Share this Question
Share on Google+
9 Replies


P: n/a
"
Specify the default language sort order (MDB)
Note The information in this topic applies only to a Microsoft Access
database (.mdb).

1.. On the Tools menu, click Options.
2.. Click the General tab.
3.. To specify the default language sort order for a new database, click
the language that you want to use in the New database sort order box.
Note To reset the sort order for an existing database to the language that
you selected in the General tab, compact that database."

set dbe = createobject("dao.dbengine.3")

'set dbe = application.dbengine

dbe.compact "from", "to", ";LANGID=0x040D;CP=1255;COUNTRY=0"

(david)

"Or" <or*@ganpooh.com> wrote in message
news:11********************@f14g2000cwb.googlegrou ps.com...
I have an access database full with data written in hebrew charecters.
any query which uses a hebrew charecter field for the ORDER BY clause
is not sorted properly.
The database is sitting in a hosting company server and is the standard
english version.
The data is entered over the internet from hebrew enabled computers.

Nov 17 '05 #2

P: n/a
set dbe = createobject("dao.dbengine.36")

'set dbe = application.dbengine

dbe.compactdatabase "from", "to", ";LANGID=0x040D;CP=1255;COUNTRY=0"
"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
news:43**********************@lon-reader.news.telstra.net...
"
Specify the default language sort order (MDB)
Note The information in this topic applies only to a Microsoft Access
database (.mdb).

1.. On the Tools menu, click Options.
2.. Click the General tab.
3.. To specify the default language sort order for a new database, click
the language that you want to use in the New database sort order box.
Note To reset the sort order for an existing database to the language
that you selected in the General tab, compact that database."

set dbe = createobject("dao.dbengine.3")

'set dbe = application.dbengine

dbe.compact "from", "to", ";LANGID=0x040D;CP=1255;COUNTRY=0"

(david)

"Or" <or*@ganpooh.com> wrote in message
news:11********************@f14g2000cwb.googlegrou ps.com...
I have an access database full with data written in hebrew charecters.
any query which uses a hebrew charecter field for the ORDER BY clause
is not sorted properly.
The database is sitting in a hosting company server and is the standard
english version.
The data is entered over the internet from hebrew enabled computers.


Nov 17 '05 #3

P: n/a
Or
I do not knoe this "dao.dbengine.36" object.
I use the following object "ADODB.Connection" in the ASP script, and it
doesn't have a compactdatabase method.

Nov 17 '05 #4

P: n/a
Or
I read about compactdatabase and saw that if I use it it will change
all my autonumbering fields and this is a not good for me.

any other idea ?

Nov 17 '05 #5

P: n/a

Or wrote:
I read about compactdatabase and saw that if I use it it will change
all my autonumbering fields and this is a not good for me.

any other idea ?


It won't change the existing autonumbers at all. It will start with
the next available number. Autonumbers are for guaranteeing
uniqueness, nothing more. If you want guaranteed sequential records,
you need to roll your own method.

Nov 17 '05 #6

P: n/a
Br
Or wrote:
I read about compactdatabase and saw that if I use it it will change
all my autonumbering fields and this is a not good for me.

any other idea ?


All it does is reset the next _available_ AutoNumber (ie. for the next
new record) to the lowest possible value based on the data in the table.
It doesn't change existing data. That would be very, very silly.
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response
Nov 17 '05 #7

P: n/a
"Or" <or*@ganpooh.com> wrote in
news:11**********************@f14g2000cwb.googlegr oups.com:
I do not knoe this "dao.dbengine.36" object.
I use the following object "ADODB.Connection" in the ASP script,
and it doesn't have a compactdatabase method.


Then you're not using Access. You're just using Jet.

You should have said that on the front end.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 17 '05 #8

P: n/a
> All it does is reset the next _available_ AutoNumber (ie. for the

AFAIK, it doesn't even do that. It only resets Empty Tables
to One.

In some (past) versions of Jet, compact used to reset
Autonumber to Max+1, but Autonumber has been broken
in Jet 4.0 since first release, and as part of the
abortive fiddling around trying to get it to work
correctly, reset to Max+1 has been dropped.

(david)
"Br@dley" <br**@usenet.org> wrote in message
news:Y6*******************@news-server.bigpond.net.au...
Or wrote:
I read about compactdatabase and saw that if I use it it will change
all my autonumbering fields and this is a not good for me.

any other idea ?


All it does is reset the next _available_ AutoNumber (ie. for the next new
record) to the lowest possible value based on the data in the table. It
doesn't change existing data. That would be very, very silly.
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response

Nov 21 '05 #9

P: n/a

"Or" <or*@ganpooh.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
I do not knoe this "dao.dbengine.36" object.
I use the following object "ADODB.Connection" in the ASP script, and it
doesn't have a compactdatabase method.


Correct. ADODB does not have a compactdatabase method.

You can't use ADODB to change the database sort order.

You will have to use a different kind of object to change
the database sort order.

You can use the dbe object to open a database object if
you wish to change the database sort order.

(david)
Nov 21 '05 #10

This discussion thread is closed

Replies have been disabled for this discussion.