Normal Topic Searching special characters (Read 2937 times)
BobBrandt
Member
*
Offline


No personal text

Posts: 6
Joined: Dec 16th, 2003
Searching special characters
Dec 20th, 2004 at 9:51pm
Print Post Print Post  
I have an opera database and since the names of operas and singers are in different languages I put in the letters with accents, umlauts, etc. My problem is that when I search using the names with just common English spellings Sesame will not pull up the record being searched for.  Ex: "Aida" will not pull up "Aïda." Is there a way around this or can Sesame be "fixed" so that I is not so particular. Q&A did not care.
Thanks for your help!

Bob
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Searching special characters
Reply #1 - Dec 20th, 2004 at 10:17pm
Print Post Print Post  
Hello Bob,

If the Opera name has diacritic characters in it, you will need to enter those same characters when you go to search for the record.

To make the ï character in sesame, with a US keyboard, you have to hit these keys.
F12 : i

The complete table of diacritic characters, and how to make them with a US keyboard, can be found on the faq page under the general section.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
BobBrandt
Member
*
Offline


No personal text

Posts: 6
Joined: Dec 16th, 2003
Re: Searching special characters
Reply #2 - Dec 20th, 2004 at 11:10pm
Print Post Print Post  
Hi Ray —
Thank you for the quick reply. I was hoping that I would not have to enter the diacritic characters. I will probably simplify things and change all to English spellings.
Thanks again!

Bob
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Searching special characters
Reply #3 - Dec 21st, 2004 at 1:11pm
Print Post Print Post  
If there is any question as to whether or not the letter is spelled with a diacritic, you can substitute it with the "?" (match any single character) in the search spec. So to search on either Aida or Aïda, use A?da in the search spec.

We hope to have an fully internationalized version of Sesame, but there are several factors outside of our control that need to be managed, primarily UTF-8 support across the platforms and libraries.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
BobBrandt
Member
*
Offline


No personal text

Posts: 6
Joined: Dec 16th, 2003
Re: Searching special characters
Reply #4 - Dec 21st, 2004 at 10:06pm
Print Post Print Post  
Yes, using wild card characters helps tremendously and works great since I know where I need to use one, in most cases.
Thanks.

Bob
  
Back to top
 
IP Logged
 
Alec
Lanticans
*****
Offline



Posts: 200
Location: Ascot, England, UK
Joined: Nov 22nd, 2002
Re: Searching special characters
Reply #5 - Dec 21st, 2004 at 10:34pm
Print Post Print Post  
Here's another approach:
Why don't you add an extra field, with the 'normal' text in it, for searching?
You could even have a keyword field with a number of entries..

Search: Verdi; Aida; Callas   ... etc

There *might* be programming which will convert these high ascii characters to 'normal' ones and so would automate this process, but I don't know it.

  

Alec
Back to top
IP Logged