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 8 2109
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" <jo**@REMOVEME.silvershot.com> wrote in message
news:g7********************************@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 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" <a@b.c.d> wrote: 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?
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" <jo**@REMOVEME.silvershot.com> wrote in message news:g7********************************@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 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
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: "TC" <a@b.c.d> wrote: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?
No, the letters are different. The one word is "odio" and the other "duo"--the words do not even have the same length!
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
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" <jo**@REMOVEME.silvershot.com> wrote in message
news:bv********************************@4ax.com... "TC" <a@b.c.d> wrote: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?
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" <jo**@REMOVEME.silvershot.com> wrote in message news:g7********************************@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 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
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... 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" <jo**@REMOVEME.silvershot.com> wrote in message news:bv********************************@4ax.com... "TC" <a@b.c.d> wrote: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?
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" <jo**@REMOVEME.silvershot.com> wrote in message news:g7********************************@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
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
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" <ho**********@spamless.ucla.edu> wrote in message
news:bm**********@gladiola.noc.ucla.edu... 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... 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" <jo**@REMOVEME.silvershot.com> wrote in message news:bv********************************@4ax.com... "TC" <a@b.c.d> wrote: >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? >
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" <jo**@REMOVEME.silvershot.com> wrote in message >news:g7********************************@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 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 >
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\u959\u8054
\u948\u8059\u959
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" <ho**********@spamless.ucla.edu> wrote: 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... 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" <jo**@REMOVEME.silvershot.com> wrote in message news:bv********************************@4ax.com... > "TC" <a@b.c.d> wrote: > >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? > > > > 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" <jo**@REMOVEME.silvershot.com> wrote in message > >news:g7********************************@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 thefirst > >> back. I can compare them and they are obviously different becausethey > >> 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 > > >
John Baima
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" <jo**@REMOVEME.silvershot.com> wrote in message
news:5a********************************@4ax.com... 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\u959\u8054
\u948\u8059\u959
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" <ho**********@spamless.ucla.edu> wrote:
Some of the hash tables were messed up in ACC2K (more properly, in the
JetEngine); 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... 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" <jo**@REMOVEME.silvershot.com> wrote in message news:bv********************************@4ax.com... > "TC" <a@b.c.d> wrote: > >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? > > > > 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" <jo**@REMOVEME.silvershot.com> wrote in message > >news:g7********************************@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 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 > > >
John Baima This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Nickolay Kolev |
last post by:
Hi all,
I have set to implementing a few basic algorithms in Python serving a
twofold purpose: learning the algorithms and learning Python a little
better.
I have however encountered a...
|
by: Rajesh Kumar Mallah |
last post by:
Hi,
I face the following problem in transferring data from
pgsql 7.3.4 to pgsql 7.4 RC1 . I am piping the output of
pg_dumpall from 7.3 to 7.4 running on different port.
The problem is there...
|
by: ashmangat |
last post by:
I'm trying to claculate the average number of characters per words but
having some problems
Every time i run this program, i get 0 as the average
#include <iostream>
#include <string>
#include...
|
by: Fei Liu |
last post by:
Yet another problem to deal with dynamic data type that can only be
determined at run time. For a netCDF file (a scientific data format), a
variable is defined with its associating dimensions, i.e....
|
by: Bo Yang |
last post by:
Hi ,
I have writen a python program to slove a problem described as below:
(Forgive my poor English !)
Put the 2^n 0 or 1 to form a ring , and we can select any continuous n
ones from
the...
|
by: HC |
last post by:
Hello, all, I started out thinking my problems were elsewhere but as I
have worked through this I have isolated my problem, currently, as a
difference between MSDE and SQL Express 2005 (I'll just...
|
by: NOO Recursion |
last post by:
Hi everyone! I am trying to write a program that will search a 12x12 for a
thing called a "blob". A blob in the grid is made up of asterisks. A blob
contains at least one asterisk. If an...
|
by: weidongtom |
last post by:
Hi,
I've written the code that follows, and I use the function add_word(),
it seems to work fine
*before* increase_arrays() is called that uses realloc() to allocate
more memory to words. But...
|
by: lightgram |
last post by:
Hi
I have a problem, which after browsing through Google, seems to be fairly common.
However having tried most suggestions I am still getting the problem.
I have a menu bar across the top...
|
by: RMWChaos |
last post by:
In my ongoing effort to produce shorter, more efficient code, I have created a "chicken and egg" / "catch-22" problem. I can think of several ways to fix this, none of them elegant.
I want my code...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |