Interesting. Nobody will be able to search for my user name, because apparently the underscore is an invalid search character.

That's not good. :X

Fixed.

And mine has three... :) Oh well, it's fixed now.

I haven't time to read through the discussion right now, but I just wanted to point out that there is a problem when searching for a phrase, e.g.:

"foo"

(with the quotes)

I get an error message saying that there is an invalid character in the search.

The quotes.

That's a problem with the search tool, then. I don't see anything invalid about quote characters. Actually, I use quotes pretty often with Google.

It's a non alphanumberic character, is my guess. Yes, I use quotes quite often in google as well, but... well, this is just a guess, so I could be wrong, but you know how certain characters need to be changed like, [space]=%20 and [quote]=%22? Well... that's probably not it (since the strings never appear in the URL), but I bet it's something related to that.

I use quotes to indicate that I want an exact phrase... It would be nice if the search understood that.

Yeah, the engine doesn't support that. But if you type the words after each other (with space in between) and no quotes, it will at least give it a higher score if they are close to each other.

I searched for "random number generator" (no quotes), and got 42 results, but Nick D's wasn't one of them!

Try "random numbar generator"

Yes...you forget that Nick D doesn't know how to spell...j/k ;)

Hey, it worked!

Why doesn't the search engine supports characters like ü and ä??? This way I (or someone else) can't search for my name ... And he won't find anything when I replace the ü with a u... Is there someway this can be fixed?

Normally, I would do something like "Vincent J*nemann", but the search doesn't seem to support wild cards either!

MWM

Allowing wildcards in the middle of a word will kill any attempt of using indexed search, and required the server to go through the entire text every time. Which will kill performance.

I will look at the issue with ü etc - there should be a way to make that work.

If you could get the underscore to work, you could probably similarly get any other ASCII character to be accepted into the string... just my guess.

postgresql? is that what their using? ew...! mySQL forever!!

mySQL isn't free as in 'Open Development' -- postgresql is. The fate of mySQL rests in the hands of one company, which is why the future DFSG UserLinux is going for postgre

Other than that, does postgresql have any advantages over MySQL? I have been using MySQL for some database work, and have been very pleased with it. I have never heard of postgresql.

MWM

From what I've heard (I don't actually use it a whole lot), mySQL isn't very scalable to very large sites. That might be why ticalc went for postgre (or mysql didn't exist back then?). Also, it doesn't support some of the more complex ANSI SQL features. On the upside, mySQL is faster for the loads it is meant to handle.

MySQL scales just fine for large sites. Many large sites use it with great success.

It has a *lot* of advantages over MySQL. (And in all fairness, MySQL has advantages ove PostgreSQL).

But this is getting grossly off-topic. If you are interested in my comments on this, send me a mail and I'll explain my views on it. (wouldn't want my own posts to be deleted by our news editors...)

<<wouldn't want my own posts to be deleted by our news editors...>>

Hehe. Wouldn't that be interesting! ;)

Yes! Wouldn't it??? :-(

you should change his post to the "[the contents of this article have been removed because of a violation of the acceptable use policy]" thing. That would be hilarious...

[the contents of this article have been removed because of a violation of the acceptable use policy]

Something tells me that you did that. Seeing that it is the last post in the thread, and MV would have deleted it.

-W-

If you do that, please send me a copy too. I haven't used PostgreSQL in about four years (6.5 days) and have been wanting a reason to look at it again.