Logo GNT
Actualités Tests & Guides Bons Plans
Twitter iPhone pliant OnePlus 11 PS5 Disney+ Orange Livebox Windows 11
Entraide Applications Microsoft Office Access Problems with index on fields using accents

Problems with index on fields using accents

2 réponses
Avatar
RobL
Hi,

I have a problem with accented characters in indexed fields in Access.

The Database:
I created a small database using French Access XP on French Windows XP SP2.
It has one table called Test and one field called Field_Text. There are two
pieces of data in the table:
Geo
Géo
and an index is built on this field.

The Code:
I wrote a small VB program that uses ADO to attempt the following query:
SELECT * FROM Test
WHERE Field_Text LIKE 'Gé%'
and the query returns no results.

This same query finds 'Géo' if the index is built on an english machine, if
there is no index built or the index is removed.

I have a workaround: WHERE Field_Text LIKE 'G[é]%' but this is a little
clumsy.

Is this a known limitation with French Access XP or am I experiencing a bug?

Thanks in advance,
RobL
i2 Ltd.
--
Software Support Engineer
i2 Ltd.
Signaler un problème avec ce contenu

2 réponses

Supprimer
Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire

Veuillez sélectionner un problème

Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
Avatar
Eric
Hello,

Sorry for my english ! :( i'm very bad

In Access, Menu Tools|Options|General, choose *General* for Type of Sort
Close Access
ReOpen Access
Execute the query and u must have the good results

--
A+
Eric
http://users.skynet.be/mpfa/
Archives : http://groups.google.fr/group/microsoft.public.fr.access?hl=fr

Hi,

I have a problem with accented characters in indexed fields in Access.

The Database:
I created a small database using French Access XP on French Windows XP SP2.
It has one table called Test and one field called Field_Text. There are two
pieces of data in the table:
Geo
Géo
and an index is built on this field.

The Code:
I wrote a small VB program that uses ADO to attempt the following query:
SELECT * FROM Test
WHERE Field_Text LIKE 'Gé%'
and the query returns no results.

This same query finds 'Géo' if the index is built on an english machine, if
there is no index built or the index is removed.

I have a workaround: WHERE Field_Text LIKE 'G[é]%' but this is a little
clumsy.

Is this a known limitation with French Access XP or am I experiencing a bug?

Thanks in advance,
RobL
i2 Ltd.


Avatar
RobL
Thanks for your response.

Unfortunately this does not solve my problem. The search for Gé* still
doesn't find any results. Is there a way to 'refresh' the database on an
english system to make it work the way a database created on an english
system does?

Thanks,

Rob
--
Software Support Engineer
i2 Ltd.


"Eric" wrote:

Hello,

Sorry for my english ! :( i'm very bad

In Access, Menu Tools|Options|General, choose *General* for Type of Sort
Close Access
ReOpen Access
Execute the query and u must have the good results

--
A+
Eric
http://users.skynet.be/mpfa/
Archives : http://groups.google.fr/group/microsoft.public.fr.access?hl=fr

Hi,

I have a problem with accented characters in indexed fields in Access.

The Database:
I created a small database using French Access XP on French Windows XP SP2.
It has one table called Test and one field called Field_Text. There are two
pieces of data in the table:
Geo
Géo
and an index is built on this field.

The Code:
I wrote a small VB program that uses ADO to attempt the following query:
SELECT * FROM Test
WHERE Field_Text LIKE 'Gé%'
and the query returns no results.

This same query finds 'Géo' if the index is built on an english machine, if
there is no index built or the index is removed.

I have a workaround: WHERE Field_Text LIKE 'G[é]%' but this is a little
clumsy.

Is this a known limitation with French Access XP or am I experiencing a bug?

Thanks in advance,
RobL
i2 Ltd.