Plz Help!!! SELECT not working with Å Æ Ø Ä Ö Characters

2007-08-11 Thread VeeJay
*From: VeeJay* <[EMAIL PROTECTED]> To: mysql@lists.mysql.com, [EMAIL PROTECTED] Date: Fri, Aug 10, 2007 at 8:19 AM Hello there I have a problem. When I try to select some names starting with extra alphabets (Å Æ Ø Ä Ö, etc), I simply don't get required results i.e., if I give a select command

Re: Plz Help!!! SELECT not working with Å Æ Ø Ä Ö Characters

2007-08-10 Thread mysql
in addition to the correct character-set also set the appropriate collation sequence suomi VeeJay wrote: Hello there I have a problem. When I try to select some names starting with extra alphabets (Å Æ Ø Ä Ö, etc), I simply don't get required results i.e., if I give a select command like: se

Plz Help!!! SELECT not working with Å Æ Ø Ä Ö Characters

2007-08-09 Thread VeeJay
Hello there I have a problem. When I try to select some names starting with extra alphabets (Å Æ Ø Ä Ö, etc), I simply don't get required results i.e., if I give a select command like: select * from employees where fname LIKE 'Å%'; I get results starting with English alphabet 'A' but not with 'Å'

Re: [PHP] Plz help quick - mysql/php/web server undefined function all of a sudden

2004-05-04 Thread Ludwig Pummer
Chip Wiegand wrote: John, Yep, looking at phpinfo.php shows no support for mysql. This is very strange. I know these things don't just happen by themselves. I also know there are only two people with the password to the server, myself and my boss (and he knows nothing about the server to begin

Re: Plz help quick - mysql/php/web server undefined function all of a sudden

2004-05-03 Thread Chip Wiegand
"Joshua J. Kugler" <[EMAIL PROTECTED]> wrote on 05/03/2004 12:23:16 PM: > It sounds like someone upgraded your PHP libraries, and forget to include > MySQL support. Do you admin this server, or does someone else? > > j- k- Yep, I ran phpinfo.php and verified that it no longer shows su

Re: Plz help quick - mysql/php/web server undefined function all of a sudden

2004-05-03 Thread Joshua J. Kugler
It sounds like someone upgraded your PHP libraries, and forget to include MySQL support. Do you admin this server, or does someone else? j- k- On Monday 03 May 2004 09:20 am, Chip Wiegand said something like: > I have a web server that uses mysql-4.1.0/apache-2.4.6/php-4.3.4 on > freebs

Re: [PHP] Plz help quick - mysql/php/web server undefined function all of a sudden

2004-05-03 Thread Chip Wiegand
"John W. Holmes" <[EMAIL PROTECTED]> wrote on 05/03/2004 10:59:15 AM: > From: "Chip Wiegand" <[EMAIL PROTECTED]> > > > I have a web server that uses mysql-4.1.0/apache-2.4.6/php-4.3.4 on > > freebsd-5.1. > > It has been working fine for the past few years, now all of a sudden today > > I get an

Plz help quick - mysql/php/web server undefined function all of a sudden

2004-05-03 Thread Chip Wiegand
I have a web server that uses mysql-4.1.0/apache-2.4.6/php-4.3.4 on freebsd-5.1. It has been working fine for the past few years, now all of a sudden today I get an undefined function error. This is from httpd-error.log - PHP Fatal error: Call to undefined function: mysql_connect() in /...

Re: My Unicode Woes - Plz Help!!!

2004-04-23 Thread Stormblade
On Thu, 22 Apr 2004 22:30:32 -0700, Dathan Vance Pattishall wrote: > 4.0.18 does not support Unicode. The JDBC driver tries to set the UNICODE > charset but can't because this mysql version cannot store Unicode data as a If it's not storing the unicode as a charset do you have any idea what it's

RE: My Unicode Woes - Plz Help!!!

2004-04-22 Thread Dathan Vance Pattishall
ginal Message- > From: news [mailto:[EMAIL PROTECTED] On Behalf Of Stormblade > Sent: Thursday, April 22, 2004 5:33 PM > To: [EMAIL PROTECTED] > Subject: My Unicode Woes - Plz Help!!! > > I'm posting this as a last ditch effort to get this working or at least > fin

My Unicode Woes - Plz Help!!!

2004-04-22 Thread Stormblade
I'm posting this as a last ditch effort to get this working or at least find out what's going on and perhaps get a workaround if one exists. Platform: Windows XP SP1 Database: MySQL 4.0.18 JDBC Drv: 3.0.11 History: There is an existing website which uses ColdFusion/SQLServer. The owner of this we

Re: plz help

2004-03-03 Thread Richard Davey
Hello CurlyBraces, Wednesday, March 3, 2004, 1:22:51 PM, you wrote: CTPL> SO i want to add colors for this status. CTPL> up = green CTPL> down = red CTPL> how can i do that ? can some body help me ..plz You asked this question a few days ago, didn't you read the reply you got last time?

plz help

2004-03-03 Thread CurlyBraces Technologies \( Pvt \) Ltd
hi ,   i have some mysql tables in my mysql database . Table name is ServiceStatus and It is included with "status" field . In the status field , it is maintainig "up" , "down" status. SO i want to add colors for this status. up = green down = red how can i do that ? can some body help me

Re: plz help a newbie

2003-12-12 Thread robert_rowe
Here is a link to the MySQL manual. Lots of good info here. http://www.mysql.com/documentation/mysql/bychapter/index.htm l The max size of a varchar is 255 characters. You will want to use one of the text data types if you are going to store long articles. I suggest mediumtext. You can find th

plz help a newbie

2003-12-12 Thread Alaios
Hi there just a lot lot lot of questions. Plz answer as many as you can. What do u prefer varchar(2) or tiny_text? What is the biggest size for the varchar? If I want to store a very big article. What is the biggest size for text that is being support? What is the difference between time

Re: plz help

2003-09-22 Thread Wajih-ur-Rehman
ginal Message - From: "Catalin PLACINTA" <[EMAIL PROTECTED]> To: "Wajih-ur-Rehman" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, September 22, 2003 2:33 PM Subject: Re: plz help > Use the LIMIT clause in mysql instead of TOP clause for access and ms

Re: plz help

2003-09-22 Thread Catalin PLACINTA
Use the LIMIT clause in mysql instead of TOP clause for access and mssql. Luck ! - Original Message - From: "Wajih-ur-Rehman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 22, 2003 12:22 PM Subject: plz help > I have this statement tha

plz help

2003-09-22 Thread Wajih-ur-Rehman
I have this statement that works perfectly fine in Access and MSSQL: (In words, i first get the top 50 id values according to the where clause and then i get the maximum of those id values) "SELECT Max(id) FROM (select top 50 id from systemevents where infoId in ( 3 ) AND id > 100 order by id A

re: plz help...tables getting corrupted...

2002-10-28 Thread Egor Egorov
Akash, Sunday, October 27, 2002, 10:49:55 AM, you wrote: A> I came across a strange problem in MySQL. Some of the tables are getting A> corrupted. The most common error messages which I encountered are : "Can't A> open file: 'tablename.MYD'. (errno: 145)" and "Got error 127 from table A> handl

RE: RE: plz help...tables getting corrupted...

2002-10-27 Thread John Meyer
Try again. -Original Message- From: [EMAIL PROTECTED] [mailto:mysql@;lists.mysql.com] Sent: Sunday, October 27, 2002 9:17 PM To: John Meyer Subject: Re: RE: plz help...tables getting corrupted... Your message cannot be posted because it appears to be either spam or simply off topic to

RE: plz help...tables getting corrupted...

2002-10-27 Thread Ed Carp
> corrupted. The most common error messages which I encountered are : "Can't > open file: 'tablename.MYD'. (errno: 145)" and "Got error 127 from table > handler". > I rectified it by shutting down the MySQL Server and using "myisamchk" > with the options -r and sometimes -o. 145 = Table was ma

plz help...tables getting corrupted...

2002-10-27 Thread Akash
Hi, I came across a strange problem in MySQL. Some of the tables are getting corrupted. The most common error messages which I encountered are : "Can't open file: 'tablename.MYD'. (errno: 145)" and "Got error 127 from table handler". I rectified it by shutting down the MySQL Server and usin

Re: Plz help w/ query

2002-01-31 Thread DL Neil
o:[EMAIL PROTECTED]] > Sent: Thursday, January 31, 2002 7:32 AM > To: [EMAIL PROTECTED] > Subject: Plz help w/ query > > > The following query displays 0 e-mails. Why? > > Tbl con_inf holds 51 records w/ 51 usernames. Tbl scr_149 holds 37 > records with 37 equivalent

RE: Plz help w/ query

2002-01-31 Thread Rick Emery
bject: Plz help w/ query The following query displays 0 e-mails. Why? Tbl con_inf holds 51 records w/ 51 usernames. Tbl scr_149 holds 37 records with 37 equivalent usernames of which 14 show date_done=0. Thanks! Anthony F. Rodriguez ([EMAIL PROT

Plz help w/ query

2002-01-31 Thread Anthony Rodriguez
The following query displays 0 e-mails. Why? Tbl con_inf holds 51 records w/ 51 usernames. Tbl scr_149 holds 37 records with 37 equivalent usernames of which 14 show date_done=0. Thanks! Anthony F. Rodriguez ([EMAIL PROTECTED]) ---

RE: Plz help w/ php/MySQL

2002-01-05 Thread Roger Baklund
* Anthony Rodriguez > The following php script successfully e-mails both messages but > it doesn't update in the table "scr_149" the column "notified". > Why? Try moving this line: > $qry_2="update scr_149 set notified='y' where username='$username'"; ...after this line: > $username=$row_1["u

Plz help w/ php/MySQL

2002-01-05 Thread Anthony Rodriguez
The following php script successfully e-mails both messages but it doesn't update in the table "scr_149" the column "notified". Why? \n"); $result_2=mysql_query($qry_2,$connection) or die ("No query # 2!"); }; mysql_free_result($result_1); $qry_3="select * from scr_149 where q05a=\"0\" && not

Re: error when installing mysql, plz help

2001-10-19 Thread Carl Troein
David Loszewski writes: > I typed './mysqladmin -u root -p password ' and this > came up, ideas on what I could do to solve this problem that I'm having? > Check that mysqld is running and that the socket: '/tmp/mysql.sock' > exists! Start mysqld before you try to connect to it. If it doesn't

error when installing mysql, plz help

2001-10-19 Thread David Loszewski
I typed './mysqladmin -u root -p password ' and this came up, ideas on what I could do to solve this problem that I'm having? By the way, I'm using the MySQL 3.23 ./mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

error when installing mysql, plz help

2001-10-19 Thread David Loszewski
I typed './mysqladmin -u root -p password ' and this came up, ideas on what I could do to solve this problem that I'm having? By the way, I'm using the MySQL 3.23 ./mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

creating/dropping index - plz help

2001-06-14 Thread Richard Clarke
Hi, I have a database with 14 million rows which contains 3 indexes. I am trying to drop two of these indexes and create another one. However each operation takes about 12 hours. Is there anyway I can make this a lot faster by changing runtime variables and similar things. Thanks in advance,

RE: MySQL-3.22.32 host.ISM not found. Plz HELP

2001-01-24 Thread Mark Maunder
ay, January 24, 2001 7:43 PM To: MySQL Subject: MySQL-3.22.32 host.ISM not found. Plz HELP Hi everybody, I'm trying to install MySQL-3.22.32 on a RH 7.0 everything looks normal but the server dies sending this message mysqld: Can't find file: 'host.ISM' (errno: 2) How

MySQL-3.22.32 host.ISM not found. Plz HELP

2001-01-24 Thread Manuel Leos
Hi everybody, I'm trying to install MySQL-3.22.32 on a RH 7.0 everything looks normal but the server dies sending this message mysqld: Can't find file: 'host.ISM' (errno: 2) How do I fix this?, Where can I get this file? or How can I build it? Thanks _