this message is about a user defined function i wrote, which
is not working well. i don't know if this is the right list,
if not, i apologize, could someone point me to the correct one?
i have written a user defined function which translates an HTML
entity representation of a letter with a diacritic into the
corresponding english alphabet letter. So it takes a string such
as kühn and translates it to kuhn or niño to nino.
the purpose is to allow searching the database by typing in
kuhn and expecting the results set to contain kü which
when displayed in HTML would be a german name.
so i wrote the function, placed it in the mysql udf framework,
used the create function syntax in mysql to load it. so far so good.
from the mysql command prompt:
mysql> select englishalpha('kühn');
it returns kuhn.
then:
mysql> select englishalpha(artistname) from tblArtworkIndex;
artistname is a field - varchar (255)
it goes away, never comes back, i have to kill mysqld and restart.
the source is here:
http://stagebaroc.berndtgroup.net/mysql/englishalpha.c
any ideas would be greatly appriciated.
dave
--
The Berndt Group, Ltd.
www.berndtgroup.com
Always Thinking.
2850 N Charles St, 2nd Fl
Baltimore, MD 21218
Email: [EMAIL PROTECTED]
Voice: (410) 889-5854
Fax: (410) 889-5904
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
