Unicode Support with MySQL

2002-10-07 Thread Schmid Manfred
Dear Ladies and Gentleman, we are very interested in using MySQL with our machines, but we need a full Unicode-support with the database. Can you give us information's about the time, when MySQL will com with a full Unicode Support? > Mit freundlichen Grüßen / Gest Regards Manfred Schmid Softw

RE: Unicode Support with MySQL

2002-10-07 Thread Dean Harding
According to the website, it'll be in version 4.1. You can already use Unicode now, though, you just can't sort on it or stuff like that... Dean Harding. -Original Message- From: Schmid Manfred [mailto:[EMAIL PROTECTED]] Sent: Monday, 7 October 2002 5:24 pm To: [EMAIL PROTECTED] Subjec

Re: need a better book

2002-10-07 Thread Niclas Hedhman
On Monday 07 October 2002 15:53, David Lloyd wrote: > > > Please let me know the name of a book(s) that teaches how these complex > > > select statements work. > > > > How about the MySQL reference manual??? > > Keep on listening to the statements made here, especially the ones you > don't underst

Full-text search and extended characters

2002-10-07 Thread Josh Santangelo
I'm working on an application that uses the MySQL full-text search to search for words in pre-existing content. This content can and does contain HTML entities like "ö". At least in my setup, if I place words like "mögliche" in an AGAINST() clause, incorrect results are returned. For example: SE

how mysql compare chars

2002-10-07 Thread lb
Dear all, I am not sure why mysql thinks char(192) = char(194) = char(193) = char(195)? mysql> select char(192)=char(193); +-+ | char(192)=char(193) | +-+ | 1 | +-+ 1 row in set (0.00 sec) mysql> select char(192)=char(

Select IN and NOT IN

2002-10-07 Thread Javier Campoamor
Hello everybody, I have a next problem to get a query working. I have some tables. A User has Phone numbers and Calls associated with each phone. # Example: All the calls of the user number 1 SELECT Call.* FROM User, Phone, Call WHERE Phone.User=1 AND Call.Phone=P

Re: looking for portnumber ...

2002-10-07 Thread hans schneidhofer
Am Montag, 7. Oktober 2002 13:07 schrieben Sie: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query > > If you just reply to this message, and inc

Re: Can't connect to local MySql server through socket '/var/lib/mysql/mysql.sock' (111)

2002-10-07 Thread Edwin Raj
Ed Carp wrote: >>On Monday 07 October 2002 12:04, Edwin Raj wrote: >> >>>When I type mysql in the command prompt it is giving the error "ERROR >>>2002: Can't connect to local MySql server through socket >>>'/var/lib/mysql/mysql.sock' (111)" >>>There is no file mysql.sock at that location??? >>> >

MySQL won't run (WinXP)

2002-10-07 Thread Thomas Andersson
Hi! I'm trying to install MySQL as it's needed for a guestbook (PHP+MySQL) but I just can't get it to work. I've downloaded both 3.23 and 4.0 and used the installed, then installed them as services. Whenever I try to start the service I get a 1067 error and it terminates, seem to be no way I can

Re: where clause question

2002-10-07 Thread Steve Edberg
Well, it depends on what exactly you mean by 'checking' Bfn1, Bfn2 and Bfn3, but you should be able to do something like this (assuming for this example that you want only want to return results where Bfn1/Bfn2/Bfn3 is equal to 99): select * from table_a as A, table_b as B where

Re: MySQL won't run (WinXP)

2002-10-07 Thread Gelu Gogancea
Hi, My opinion: You must be sure that my.cnf is on "c:\" or if you use my.ini configuration files, that file is on c:\windows Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED]

ÖйúÕÐÉÌÒý×ÊÍø£º×£¹úÇì½Ú¿ìÀÖ£¡

2002-10-07 Thread zsyz
ÖйúÕÐÉÌÒý×ÊÍøÎªÄúÀ©´óÕÐÉÌ£¡