Jonas Sandman <[EMAIL PROTECTED]>
wrote:
ext1 is one type of extension, in my case 'mp3'. I guess it doesn't
make
sense when you have only one, but potentially there can be a lot more
there. ('mp3', 'ogg', 'flac') etc...
And how exactly do you plan to specify such a list in a parameter?
Unfortunately, "COLLATION STRIP_ACCENT LIKE" doesn't seem to trigger
anything either.
First, it's "COLLATE", not "COLLATION". Second, LIKE doesn't use
collations. Note that a collation doesn't convert one string to another,
it just tells how two strings should be ordered. This information is
useless to LIKE.
What you probably want is a custom function, not a custom collation. A
function would take a string and return another string, with accents
removed. You can then use it like this:
select * from tableName
where StripAccents(field) = value;
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
