CONVERT CHARACTER SET option work on TEXT fields?

Folks -- I'm using Client version:mysql Ver 14.6 Distrib 4.1.5-gamma, for pc-linux (i686) Server version: 4.1.5-gamma-standard-log They both happen to both be on the same system, which is RHEL AS 3. All defaults are now UTF8: Server characterset:utf8 Db characterset:u

general query log

inutes) without having to stop and restart? (2) Is there some way to get similar output with a different tool? [mysql query] TIA, Andy Andy Ingham Systems Librarian Academic Affairs Library UNC-Chapel Hill 919-962-1288 [EMAIL PROTECTED] --

handling of diacritics?

k for all ASCII characters. Additionally, there is a way to retrieve the ASCII number assigned to a given character, but not vice versa. Is there any way to have 'ü' match on a 'u' in a search string, etc., etc., etc.? sql TIA, Andy Andy Ingham Systems Librarian Academic Affa

Re: query optimization with CONCAT query

IN BOOLEAN MODE So if mysql 4 is an option, I think that would work for you. http://www.mysql.com/doc/en/Fulltext_Search.html olinux --- Andy Ingham <[EMAIL PROTECTED]> wrote: Folks -- We have built a table with bibliographic information that contains a field for initial articles and

query optimization with CONCAT query

* within any of the fields defined in that index. Any ideas of how to address this issue? TIA for any insights, Andy Andy Ingham Systems Librarian Academic Affairs Library UNC-Chapel Hill 919-962-1288 [EMAIL PROTECTED] ---

Re: describe all tables

A fellow in our shop wrote a perl script to do just that. Enjoy! Andy Andy Ingham Systems Librarian Academic Affairs Library UNC-Chapel Hill 919-962-1288 [EMAIL PROTECTED] * #!/usr/local

Re: Coldfusion?

bility of the system, with no other MySQL changes. If you are thinking of running CF on Solaris, save yourself the headaches and use PHP instead. I can't speak to it's performance on Windows. My 2 cents, Andy Andy Ingham Systems Librarian Academic Affairs Library UNC-Chapel Hill