Subject | confused with charset and collation |
---|---|
Author | Didier Gasser-Morlay |
Post date | 2004-06-03T12:59:33Z |
After reading a good deal of post re charset and collation, I am very
confused.
I will have English (british), German and french users, entering data
in the very same fields with or without accents, with a combination of
upper and lowercase.
Problem 1: I need all of them to query the data with or without
accents, and with possibly a combination of upper and lowercase. This
is the most pressing issue. The search is achieved using either exact
combination or Like (STARTING WITH)
Problem 2: when sorting by that field, I would ideally like to have
the sort order case and accent insensitive. If this cannot be
achieved, I can probably leave with that.
What is the correct (or best) combination or charset/collation using
fb 1.5, Bearing in mind that the database is queried via a delphi
application and via a php-based browser front end.
Thanks a lot for your help
Didier
confused.
I will have English (british), German and french users, entering data
in the very same fields with or without accents, with a combination of
upper and lowercase.
Problem 1: I need all of them to query the data with or without
accents, and with possibly a combination of upper and lowercase. This
is the most pressing issue. The search is achieved using either exact
combination or Like (STARTING WITH)
Problem 2: when sorting by that field, I would ideally like to have
the sort order case and accent insensitive. If this cannot be
achieved, I can probably leave with that.
What is the correct (or best) combination or charset/collation using
fb 1.5, Bearing in mind that the database is queried via a delphi
application and via a php-based browser front end.
Thanks a lot for your help
Didier