Problem with Index

[John Baima]

I have an Access table that just consists of 2 columns: WordID
(Autonumber, Primary key) and WordText (Text, Indexed, No dups). I've
used this with a number of texts and languages without any problems.
With my first Unicode Greek text, I've encountered a problem. The
first 2 words of the text are "o(doi\ du/o". Now, those obviously are
not the same words, but after I add the first, the second cannot be
added because it thinks that I am making a duplicate entry. In fact,
in a C# program, I select based on the second word and I get the first
back. I can compare them and they are obviously different because they
are not even the same length. There must be a bug in the Access
indexing hash routine. Is there any way for me to change the behavior
of the index? Has anyone see anything like this?

-John

[TC]

Re: Problem with Index

Remember that Access indexing is case independent (so the presence of "abc"
will prevent the addition of "ABC"). Is it anything to do with that?

HTH,
TC


"John Baima" <john@REMOVEME. silvershot.com> wrote in message
news:g70eovg6qn nqoph8vk10692iu lfv9s5obj@4ax.c om...[color=blue]
> I have an Access table that just consists of 2 columns: WordID
> (Autonumber, Primary key) and WordText (Text, Indexed, No dups). I've
> used this with a number of texts and languages without any problems.
> With my first Unicode Greek text, I've encountered a problem. The
> first 2 words of the text are "o(doi\ du/o". Now, those obviously are
> not the same words, but after I add the first, the second cannot be
> added because it thinks that I am making a duplicate entry. In fact,
> in a C# program, I select based on the second word and I get the first
> back. I can compare them and they are obviously different because they
> are not even the same length. There must be a bug in the Access
> indexing hash routine. Is there any way for me to change the behavior
> of the index? Has anyone see anything like this?
>
> -John[/color]

[John Baima]

Re: Problem with Index

"TC" <a@b.c.d> wrote:[color=blue]
>Remember that Access indexing is case independent (so the presence of "abc"
>will prevent the addition of "ABC"). Is it anything to do with that?
>[/color]

No, the letters are different. The one word is "odio" and the other
"duo"--the words do not even have the same length!
[color=blue]
>
>
>"John Baima" <john@REMOVEME. silvershot.com> wrote in message
>news:g70eovg6q nnqoph8vk10692i ulfv9s5obj@4ax. com...[color=green]
>> I have an Access table that just consists of 2 columns: WordID
>> (Autonumber, Primary key) and WordText (Text, Indexed, No dups). I've
>> used this with a number of texts and languages without any problems.
>> With my first Unicode Greek text, I've encountered a problem. The
>> first 2 words of the text are "o(doi\ du/o". Now, those obviously are
>> not the same words, but after I add the first, the second cannot be
>> added because it thinks that I am making a duplicate entry. In fact,
>> in a C# program, I select based on the second word and I get the first
>> back. I can compare them and they are obviously different because they
>> are not even the same length. There must be a bug in the Access
>> indexing hash routine. Is there any way for me to change the behavior
>> of the index? Has anyone see anything like this?
>>
>> -John[/color]
>[/color]

[Peter Russell]

Re: Problem with Index

This is probably too techie for me as it may well involve code pages or
such but on my UK A2002 setup i have no problem with entering both words.
In fact I can do the following entries.

The entries are

ID WordText
1 o(doi\
2 du/o
3 odoi
4 duo

Regards

Peter Russell


John Baima previously wrote:
[color=blue]
> "TC" <a@b.c.d> wrote:[color=green]
> >Remember that Access indexing is case independent (so the presence of[/color]
> "abc"[color=green]
> >will prevent the addition of "ABC"). Is it anything to do with that?
> >[/color]
>
> No, the letters are different. The one word is "odio" and the other
> "duo"--the words do not even have the same length!
>[color=green]
> >[color=darkred]
> >> are not even the same length. There must be a bug in the Access
> >> indexing hash routine. Is there any way for me to change the behavior
> >> of the index? Has anyone see anything like this?
> >>
> >> -John[/color]
> >[/color]
>
>[/color]

[TC]

Re: Problem with Index

Is it anything to do with two letters being treated as one? (eg. oe in
english) - diacritics, or something?

The other respondent says that he can do it. Are you sure there isn't
another unique index on some other field in the table?

TC


"John Baima" <john@REMOVEME. silvershot.com> wrote in message
news:bvufovk7lh u4cbrceah8gr68v 448vrs9nu@4ax.c om...[color=blue]
> "TC" <a@b.c.d> wrote:[color=green]
> >Remember that Access indexing is case independent (so the presence of[/color][/color]
"abc"[color=blue][color=green]
> >will prevent the addition of "ABC"). Is it anything to do with that?
> >[/color]
>
> No, the letters are different. The one word is "odio" and the other
> "duo"--the words do not even have the same length!
>[color=green]
> >
> >
> >"John Baima" <john@REMOVEME. silvershot.com> wrote in message
> >news:g70eovg6q nnqoph8vk10692i ulfv9s5obj@4ax. com...[color=darkred]
> >> I have an Access table that just consists of 2 columns: WordID
> >> (Autonumber, Primary key) and WordText (Text, Indexed, No dups). I've
> >> used this with a number of texts and languages without any problems.
> >> With my first Unicode Greek text, I've encountered a problem. The
> >> first 2 words of the text are "o(doi\ du/o". Now, those obviously are
> >> not the same words, but after I add the first, the second cannot be
> >> added because it thinks that I am making a duplicate entry. In fact,
> >> in a C# program, I select based on the second word and I get the first
> >> back. I can compare them and they are obviously different because they
> >> are not even the same length. There must be a bug in the Access
> >> indexing hash routine. Is there any way for me to change the behavior
> >> of the index? Has anyone see anything like this?
> >>
> >> -John[/color]
> >[/color]
>[/color]

[Bruce Rusk]

Re: Problem with Index

Some of the hash tables were messed up in ACC2K (more properly, in the Jet
Engine); I had a similar problem with the traditional Chinese sort order.

In Tools -> Options -> General, what sort order do you have selected? And
what language version of Windows are you using?


"TC" <a@b.c.d> wrote in message news:1065931392 .729812@teuthos ...[color=blue]
> Is it anything to do with two letters being treated as one? (eg. oe in
> english) - diacritics, or something?
>
> The other respondent says that he can do it. Are you sure there isn't
> another unique index on some other field in the table?
>
> TC
>
>
> "John Baima" <john@REMOVEME. silvershot.com> wrote in message
> news:bvufovk7lh u4cbrceah8gr68v 448vrs9nu@4ax.c om...[color=green]
> > "TC" <a@b.c.d> wrote:[color=darkred]
> > >Remember that Access indexing is case independent (so the presence of[/color][/color]
> "abc"[color=green][color=darkred]
> > >will prevent the addition of "ABC"). Is it anything to do with that?
> > >[/color]
> >
> > No, the letters are different. The one word is "odio" and the other
> > "duo"--the words do not even have the same length!
> >[color=darkred]
> > >
> > >
> > >"John Baima" <john@REMOVEME. silvershot.com> wrote in message
> > >news:g70eovg6q nnqoph8vk10692i ulfv9s5obj@4ax. com...
> > >> I have an Access table that just consists of 2 columns: WordID
> > >> (Autonumber, Primary key) and WordText (Text, Indexed, No dups). I've
> > >> used this with a number of texts and languages without any problems.
> > >> With my first Unicode Greek text, I've encountered a problem. The
> > >> first 2 words of the text are "o(doi\ du/o". Now, those obviously are
> > >> not the same words, but after I add the first, the second cannot be
> > >> added because it thinks that I am making a duplicate entry. In fact,
> > >> in a C# program, I select based on the second word and I get the[/color][/color][/color]
first[color=blue][color=green][color=darkred]
> > >> back. I can compare them and they are obviously different because[/color][/color][/color]
they[color=blue][color=green][color=darkred]
> > >> are not even the same length. There must be a bug in the Access
> > >> indexing hash routine. Is there any way for me to change the behavior
> > >> of the index? Has anyone see anything like this?
> > >>
> > >> -John
> > >[/color]
> >[/color]
>
>[/color]

[TC]

Re: Problem with Index

Sorry, can not answer your second question - I don't have Access on this PC!

Note it was the other respondent who said he could do it - not me.

TC


"Bruce Rusk" <homaisnospam@s pamless.ucla.ed u> wrote in message
news:bmbrga$5e3 $1@gladiola.noc .ucla.edu...[color=blue]
> Some of the hash tables were messed up in ACC2K (more properly, in the Jet
> Engine); I had a similar problem with the traditional Chinese sort order.
>
> In Tools -> Options -> General, what sort order do you have selected? And
> what language version of Windows are you using?
>
>
> "TC" <a@b.c.d> wrote in message news:1065931392 .729812@teuthos ...[color=green]
> > Is it anything to do with two letters being treated as one? (eg. oe in
> > english) - diacritics, or something?
> >
> > The other respondent says that he can do it. Are you sure there isn't
> > another unique index on some other field in the table?
> >
> > TC
> >
> >
> > "John Baima" <john@REMOVEME. silvershot.com> wrote in message
> > news:bvufovk7lh u4cbrceah8gr68v 448vrs9nu@4ax.c om...[color=darkred]
> > > "TC" <a@b.c.d> wrote:
> > > >Remember that Access indexing is case independent (so the presence of[/color]
> > "abc"[color=darkred]
> > > >will prevent the addition of "ABC"). Is it anything to do with that?
> > > >
> > >
> > > No, the letters are different. The one word is "odio" and the other
> > > "duo"--the words do not even have the same length!
> > >
> > > >
> > > >
> > > >"John Baima" <john@REMOVEME. silvershot.com> wrote in message
> > > >news:g70eovg6q nnqoph8vk10692i ulfv9s5obj@4ax. com...
> > > >> I have an Access table that just consists of 2 columns: WordID
> > > >> (Autonumber, Primary key) and WordText (Text, Indexed, No dups).[/color][/color][/color]
I've[color=blue][color=green][color=darkred]
> > > >> used this with a number of texts and languages without any[/color][/color][/color]
problems.[color=blue][color=green][color=darkred]
> > > >> With my first Unicode Greek text, I've encountered a problem. The
> > > >> first 2 words of the text are "o(doi\ du/o". Now, those obviously[/color][/color][/color]
are[color=blue][color=green][color=darkred]
> > > >> not the same words, but after I add the first, the second cannot be
> > > >> added because it thinks that I am making a duplicate entry. In[/color][/color][/color]
fact,[color=blue][color=green][color=darkred]
> > > >> in a C# program, I select based on the second word and I get the[/color][/color]
> first[color=green][color=darkred]
> > > >> back. I can compare them and they are obviously different because[/color][/color]
> they[color=green][color=darkred]
> > > >> are not even the same length. There must be a bug in the Access
> > > >> indexing hash routine. Is there any way for me to change the[/color][/color][/color]
behavior[color=blue][color=green][color=darkred]
> > > >> of the index? Has anyone see anything like this?
> > > >>
> > > >> -John
> > > >
> > >[/color]
> >
> >[/color]
>
>[/color]

[John Baima]

Re: Problem with Index

I'm using Windows XP Pro with US-English. In Tools | Options |
General, for "New Database sort order" I have "General".

The problem is that Access is ignoring the "Extended Greek" in the
\U80xx code page. The Greek characters in the \U09xx code page are
included. The two words I had a problem with were:

\u8001\u948\u95 9\u8054

\u948\u8059\u95 9

Access will not allow you to enter \u948\u959 either. Is there any
workaround for this?

BTW, I think that this problem also shows in SQL Server as well.



"Bruce Rusk" <homaisnospam@s pamless.ucla.ed u> wrote:
[color=blue]
>Some of the hash tables were messed up in ACC2K (more properly, in the Jet
>Engine); I had a similar problem with the traditional Chinese sort order.
>
>In Tools -> Options -> General, what sort order do you have selected? And
>what language version of Windows are you using?
>
>
>"TC" <a@b.c.d> wrote in message news:1065931392 .729812@teuthos ...[color=green]
>> Is it anything to do with two letters being treated as one? (eg. oe in
>> english) - diacritics, or something?
>>
>> The other respondent says that he can do it. Are you sure there isn't
>> another unique index on some other field in the table?
>>
>> TC
>>
>>
>> "John Baima" <john@REMOVEME. silvershot.com> wrote in message
>> news:bvufovk7lh u4cbrceah8gr68v 448vrs9nu@4ax.c om...[color=darkred]
>> > "TC" <a@b.c.d> wrote:
>> > >Remember that Access indexing is case independent (so the presence of[/color]
>> "abc"[color=darkred]
>> > >will prevent the addition of "ABC"). Is it anything to do with that?
>> > >
>> >
>> > No, the letters are different. The one word is "odio" and the other
>> > "duo"--the words do not even have the same length!
>> >
>> > >
>> > >
>> > >"John Baima" <john@REMOVEME. silvershot.com> wrote in message
>> > >news:g70eovg6q nnqoph8vk10692i ulfv9s5obj@4ax. com...
>> > >> I have an Access table that just consists of 2 columns: WordID
>> > >> (Autonumber, Primary key) and WordText (Text, Indexed, No dups). I've
>> > >> used this with a number of texts and languages without any problems.
>> > >> With my first Unicode Greek text, I've encountered a problem. The
>> > >> first 2 words of the text are "o(doi\ du/o". Now, those obviously are
>> > >> not the same words, but after I add the first, the second cannot be
>> > >> added because it thinks that I am making a duplicate entry. In fact,
>> > >> in a C# program, I select based on the second word and I get the[/color][/color]
>first[color=green][color=darkred]
>> > >> back. I can compare them and they are obviously different because[/color][/color]
>they[color=green][color=darkred]
>> > >> are not even the same length. There must be a bug in the Access
>> > >> indexing hash routine. Is there any way for me to change the behavior
>> > >> of the index? Has anyone see anything like this?
>> > >>
>> > >> -John
>> > >
>> >[/color]
>>
>>[/color]
>[/color]

John Baima

[TC]

Re: Problem with Index

There are a few people who would definitely know the answer to this. It
surprises me that they haven't replied. Perhaps repost your question in a
new thread in a day or two. Personally, as soon as I see the words "code
page", my eyes glaze over, & I start to tremble uncontrollably. ..

TC


"John Baima" <john@REMOVEME. silvershot.com> wrote in message
news:5adlovcj42 t6vflcc1t5p7o53 l5re57j5b@4ax.c om...[color=blue]
> I'm using Windows XP Pro with US-English. In Tools | Options |
> General, for "New Database sort order" I have "General".
>
> The problem is that Access is ignoring the "Extended Greek" in the
> \U80xx code page. The Greek characters in the \U09xx code page are
> included. The two words I had a problem with were:
>
> \u8001\u948\u95 9\u8054
>
> \u948\u8059\u95 9
>
> Access will not allow you to enter \u948\u959 either. Is there any
> workaround for this?
>
> BTW, I think that this problem also shows in SQL Server as well.
>
>
>
> "Bruce Rusk" <homaisnospam@s pamless.ucla.ed u> wrote:
>[color=green]
> >Some of the hash tables were messed up in ACC2K (more properly, in the[/color][/color]
Jet[color=blue][color=green]
> >Engine); I had a similar problem with the traditional Chinese sort order.
> >
> >In Tools -> Options -> General, what sort order do you have selected? And
> >what language version of Windows are you using?
> >
> >
> >"TC" <a@b.c.d> wrote in message news:1065931392 .729812@teuthos ...[color=darkred]
> >> Is it anything to do with two letters being treated as one? (eg. oe in
> >> english) - diacritics, or something?
> >>
> >> The other respondent says that he can do it. Are you sure there isn't
> >> another unique index on some other field in the table?
> >>
> >> TC
> >>
> >>
> >> "John Baima" <john@REMOVEME. silvershot.com> wrote in message
> >> news:bvufovk7lh u4cbrceah8gr68v 448vrs9nu@4ax.c om...
> >> > "TC" <a@b.c.d> wrote:
> >> > >Remember that Access indexing is case independent (so the presence[/color][/color][/color]
of[color=blue][color=green][color=darkred]
> >> "abc"
> >> > >will prevent the addition of "ABC"). Is it anything to do with that?
> >> > >
> >> >
> >> > No, the letters are different. The one word is "odio" and the other
> >> > "duo"--the words do not even have the same length!
> >> >
> >> > >
> >> > >
> >> > >"John Baima" <john@REMOVEME. silvershot.com> wrote in message
> >> > >news:g70eovg6q nnqoph8vk10692i ulfv9s5obj@4ax. com...
> >> > >> I have an Access table that just consists of 2 columns: WordID
> >> > >> (Autonumber, Primary key) and WordText (Text, Indexed, No dups).[/color][/color][/color]
I've[color=blue][color=green][color=darkred]
> >> > >> used this with a number of texts and languages without any[/color][/color][/color]
problems.[color=blue][color=green][color=darkred]
> >> > >> With my first Unicode Greek text, I've encountered a problem. The
> >> > >> first 2 words of the text are "o(doi\ du/o". Now, those obviously[/color][/color][/color]
are[color=blue][color=green][color=darkred]
> >> > >> not the same words, but after I add the first, the second cannot[/color][/color][/color]
be[color=blue][color=green][color=darkred]
> >> > >> added because it thinks that I am making a duplicate entry. In[/color][/color][/color]
fact,[color=blue][color=green][color=darkred]
> >> > >> in a C# program, I select based on the second word and I get the[/color]
> >first[color=darkred]
> >> > >> back. I can compare them and they are obviously different because[/color]
> >they[color=darkred]
> >> > >> are not even the same length. There must be a bug in the Access
> >> > >> indexing hash routine. Is there any way for me to change the[/color][/color][/color]
behavior[color=blue][color=green][color=darkred]
> >> > >> of the index? Has anyone see anything like this?
> >> > >>
> >> > >> -John
> >> > >
> >> >
> >>
> >>[/color]
> >[/color]
>
> John Baima[/color]