You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by Danny Yuan <da...@gmail.com> on 2006/02/11 18:24:07 UTC

Does Derby support soundex

Hi,

May I know if Derby support soundex? I ran some query like "select 
mytable where soundex(mytable.field) = soundex('a')", and got error 
message SQL Exception: 'SOUNDEX' is not recognized as a function or 
procedure. However, if I remember correctly, previous versions of 
cloudscape supported soundex. If Derby does support soundex, do I need 
to configure something before soundex can be recognized as a function or 
procedure by Derby? Thanks.


Regards,

Danny

RE: Does Derby support soundex

Posted by mark boylan <ma...@hotmail.com>.

Hi Danny,

I've been using commons codec for that.

- mark



>
>Hi,
>
>May I know if Derby support soundex? I ran some query like "select mytable 
>where soundex(mytable.field) = soundex('a')", and got error message SQL 
>Exception: 'SOUNDEX' is not recognized as a function or procedure. However, 
>if I remember correctly, previous versions of cloudscape supported soundex. 
>If Derby does support soundex, do I need to configure something before 
>soundex can be recognized as a function or procedure by Derby? Thanks.
>
>
>Regards,
>
>Danny