tsearch2, PHP5 with Bidi + US-ASCII

Hello Nerds, Geeks and Gurus,

I have a multilingual Database of arround 380 to 390 GByte with data
in environement 60 languages. the entired Database is INICODE.

Since version 5, PHP is supporting UNICODE very nice, but whenever I
want to search a bidi-string (farsi, arabic or hebrew) it returns
nothing. Languages like chinese or russian are working perfect.

Whats going wrong here?

Greetings
Michelle Konzack
Systemadministrator
Tamay Dogan Network
Debian GNU/Linux Consultant


--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/6/61925193 67100 Strasbourg/France IRC #Debian (irc.icq.com)

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: tsearch2, PHP5 with Bidi + US-ASCII

Michelle Konzack wrote:
> Hello Nerds, Geeks and Gurus,
>
> I have a multilingual Database of arround 380 to 390 GByte with data
> in environement 60 languages. the entired Database is INICODE.
>
> Since version 5, PHP is supporting UNICODE very nice, but whenever I
> want to search a bidi-string (farsi, arabic or hebrew) it returns
> nothing. Languages like chinese or russian are working perfect.
>
> Whats going wrong here?

You're using postgres aren't you ? If you copy/paste the query and run
it through psql do you get results?

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: tsearch2, PHP5 with Bidi + US-ASCII

Am 2006-09-08 06:53:10, schrieb Chris:

> You're using postgres aren't you ? If you copy/paste the query and run

Yes ;-)

> it through psql do you get results?

This is what I have already tried... and WHY I do not find the error.

Greetings
Michelle Konzack
Systemadministrator
Tamay Dogan Network
Debian GNU/Linux Consultant


--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/6/61925193 67100 Strasbourg/France IRC #Debian (irc.icq.com)

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: tsearch2, PHP5 with Bidi + US-ASCII

Michelle Konzack wrote:
> Am 2006-09-08 06:53:10, schrieb Chris:
>
>> You're using postgres aren't you ? If you copy/paste the query and run
>
> Yes ;-)

considering tsearch was in the subject that was rather a silly question
wasn't it ;)

>> it through psql do you get results?
>
> This is what I have already tried... and WHY I do not find the error.

So you do get results running the query through psql but not through php?

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: tsearch2, PHP5 with Bidi + US-ASCII

Am 2006-09-11 10:40:06, schrieb Chris:
> Michelle Konzack wrote:
> >Am 2006-09-08 06:53:10, schrieb Chris:
> >
> >>You're using postgres aren't you ? If you copy/paste the query and run
> >
> >Yes ;-)
>
> considering tsearch was in the subject that was rather a silly question
> wasn't it ;)
>
> >>it through psql do you get results?
> >
> >This is what I have already tried... and WHY I do not find the error.
>
> So you do get results running the query through psql but not through php?

Yes.

I have tested following:

1) Text to search has ONLY RTL language (farsi, arabic, hebrew)
and search string is RTL. - Works perfectly using pgadmin and
then a UNICODE Terminal with psql.

2) Text to search has ONLY RTL AND LTR language (e.g. farsi + german)
and search string is RTL. - Works perfectly using pgadmin and
then a UNICODE Terminal with psql.

3) Text to search has ONLY RTL AND LTR language (e.g. farsi + german)
and search string is RTL AND LTR. - Failed on both pgadmin and
psql.

Then I have echoed the SELECT string from PHP5 into a RTL capable
UNICODE viewer and all is shown right.

This let my brain smoking... since I need this Type of search.

If you search things like this in Google it works perfectly!
Maybe Google IS God!


Greetings
Michelle Konzack
Systemadministrator
Tamay Dogan Network
Debian GNU/Linux Consultant


--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/6/61925193 67100 Strasbourg/France IRC #Debian (irc.icq.com)

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php