UTF-8 Collation

2004-05-03 Thread Gavin McCullagh
Hi, I recently tried MySQL 4.1.1-alpha in order to get proper UTF-8 support. I need to be able to order on a utf8 text field. Accented characters should (broadly) be treated as though they were not accented for ordering purposes. Many of the european charsets (eg German) seem to have special

REPLACE() wildcards

2002-04-23 Thread Gavin McCullagh
Hi, When using the REPLACE() function in a query, are there any wildcards allowed? If so what are they? Also are regular expressions only usable for matching or can one also do a regular expression substitute in some way? Thanks Gavin

Regexps Order By

2002-04-13 Thread Gavin McCullagh
allow this type of work? What I'm doing may seem rather odd but using Unicode wasn't really practical for us and Latex is the best way to achieve the sort of strange phonetic characters and so forth that we routinely use. Thanks for any help, Gavin McCullagh Dept of Celtic Studies Dublin Institute