Brooks, this isn't an answer to your question, but a question to you
regarding what you have done.
I would like to do a query such as:
SELECT title FROM books WHERE title LIKE '%Francais%';
And in return get:
+--+
| title|
+--+
| Français |
+--+
Does the CHARACTER SET
Can anyone explain how to setup a table that contains text in any
language for searching using english characters?
Let's say I want to search for the word Francais, but in the database
it is stored as Français.
Any help is appreciated
Andrew
--
MySQL General Mailing List
For list archives:
DBVisualizer, it's great and FREE
Attila Horvath wrote:
Does anyone know where I can get the [latest] free version of MySchema?
Seems both brandosoftware.com fell off the edge of the world - MySchema
along with it.
Failing that I'm looking for a free/reasonable ERD tool.
Any/all suggestions
Brown, Brooks wrote:
I ran mysqld with arguments --default-character-set=utf8 and --default-collation=utf8_unicode_ci, and created a table with no collation specification. I didn't test specifically with ç, but e and e-acute were equivalent. For me this is was problem, but it sounds like for you