spongebob Posted January 26, 2011 Share Posted January 26, 2011 Hi Forum. in Filemaker 11 I have several records with Name and Surname like this Paul Müller Peter Muller John Müller Simon Mütz If I search for all with surname "Mu" (without the quotes of course), *all* 4 records are found, including those with Umlauts. However if I search for "Muller" it ONLY finds the Muller one. Is that logical? What logic does Filemaker apply here? Should it not find three records if I search for Muller? like this: Müller Muller Müller Any light that may be shed on my darkness is much appreciated. :) Link to comment Share on other sites More sharing options...
comment Posted January 26, 2011 Share Posted January 26, 2011 Two questions: 1. What is the default language set for the field's indexing? 2. In the case of "Müller", what do you get as the result of = Code ( Left ( text ; 3 ) ) Link to comment Share on other sites More sharing options...
spongebob Posted January 27, 2011 Author Share Posted January 27, 2011 Two questions: 1. What is the default language set for the field's indexing? 2. In the case of "Müller", what do you get as the result of = Code ( Left ( text ; 3 ) ) 1. German (my Filemaker is in Englisch though) 2. I dont have a function called Code... Left ( text ; 3 ) gives as expected "Mul" or "Mül" or "Müt" Im Puzzled. I have another different DB where i found that this actually works as I would anticipate, am now trying to figure out why it doesnt work here... Thanx Link to comment Share on other sites More sharing options...
comment Posted January 27, 2011 Share Posted January 27, 2011 I dont have a function called Code... Are you using version 11 as your profile says? http://www.filemaker.com/11help/html/func_ref3.33.46.html#1051087 See here for a possible suspect: http://fmforums.com/forum/topic/64240-limitations-to-code-and-char/page__p__304655#entry304655 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4835 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now