Re: contrib/levenshtein() has a bug?

Ah, yes, you are correct.

Hm, it's too bad levenshtein() is ascii-only.

On Thu, 28 Sep 2006, Tom Lane wrote:

> Ben <bench(at)silentmedia(dot)com> writes:
>> The levenshtein function from contrib/fuzzystrmatch.sql has a max arg
>> length of 255. OK, that's cool. But check this out:
>
>> mbrainz_db=> select max(length(name)) from public.track;
>> max
>> -----
>> 255
>> (1 row)
>
>> mbrainz_db=> select levenshtein(name,'foo') from public.track;
>> ERROR: argument exceeds max length: 255
>
>> That seems odd.
>
> length() measures in characters whereas the limit in question is being
> enforced in bytes. You got any multibyte characters in there?
>
> (It looks to me like levenshtein() is utterly non-multibyte-aware,
> which is probably a bug in itself.)
>
> regards, tom lane
>