Re: i have a problem with judge some words contain chinese word!

On Mar 30, 2009, at 10:14 , shiguoying wrote:

>
> Hello:
>    I have a problem with juding some words contain chinese word.
>
>    I found that with oracle.but i can't find it in postgresql.
>    oracle? has acsiistr and lengthb to deal with it.i wonna to know
> postgresql how to !
> ???          thx !
>                                                                from
> eagle

You can use regexp_replace to remove sets of charcters and then
compare lengths or even the strings themselves:

SELECT some_text, LENGTH(some_text), re, LENGTH(re), some_text = re as
str_eq, LENGTH(some_text) = LENGTH(re) AS len_eq
   FROM (SELECT some_text, regexp_replace(some_text, $re$[^[:ascii:]]
$re$, '', 'g') as re
          FROM (VALUES ('foo'), ('foo bar baz'), ('foo.bar,baz'), ('foo
案')) AS samples(some_text)) AS s;

   some_text  | length |     re      | length | str_eq | len_eq
-------------+--------+-------------+--------+--------+--------
  foo         |      3 | foo         |      3 | t      | t
  foo bar baz |     11 | foo bar baz |     11 | t      | t
  foo.bar,baz |     11 | foo.bar,baz |     11 | t      | t
  foo案       |      4 | foo         |      3 | f      | f
(4 rows)

Michael Glaesemann
grzm seespotcode net