*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
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
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 'Å'
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
"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
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
"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
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
/...
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
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
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
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?
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
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
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
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
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
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
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
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
> 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
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
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
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
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])
---
* 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
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
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
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)
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)
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,
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
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
_
33 matches
Mail list logo