Subject | select where field contains non-ascii characters |
---|---|
Author | Erik LaBianca |
Post date | 2006-11-01T16:00:48Z |
Hello All,
Apologies if this has been covered before, google isn't getting me very
far.
I'd like to be able to select rows in firebird 1.5.3 that contain
non-ascii characters. Something like select * from table where not
isalnum(field). Is there an elegant way to do this without resorting to
writing and deploying a custom UDF? If I need a UDF, is there a library
already out there with a suitable function in it? I'm not seeing
anything that looks like it could do it in fbudf or ib_udf.
Thanks
--erik
[Non-text portions of this message have been removed]
Apologies if this has been covered before, google isn't getting me very
far.
I'd like to be able to select rows in firebird 1.5.3 that contain
non-ascii characters. Something like select * from table where not
isalnum(field). Is there an elegant way to do this without resorting to
writing and deploying a custom UDF? If I need a UDF, is there a library
already out there with a suitable function in it? I'm not seeing
anything that looks like it could do it in fbudf or ib_udf.
Thanks
--erik
[Non-text portions of this message have been removed]