*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
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
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:
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
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
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 undefined
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
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 support
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
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
-
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
find out what's going on and perhaps get a workaround
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
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 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
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
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
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 that works perfectly fine in Access
-
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 mssql.
Luck !
- Original Message -
From: Wajih-ur-Rehman
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 handler.
A
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 using
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 marked as
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
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.
?php
$connection=mysql_connect(localhost,wagner,xxx) or die (No
connection!);
: 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.
?php
$connection=mysql_connect(localhost,wagner,xxx) or die (No
connection!);
$db
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 usernames of which 14 show date_done=0.
?php
$connection=mysql_connect(localhost,wagner
The following php script successfully e-mails both messages but it doesn't
update in the table scr_149 the column notified. Why?
?php
// file: root/adm/e_mail.php, updated: 01/05/02
$connection=mysql_connect(localhost,wagner,123) or die (No
connection!);
// db
* 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[username];
I typed './mysqladmin -u root -p password my new 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
I typed './mysqladmin -u root -p password my new 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
David Loszewski writes:
I typed './mysqladmin -u root -p password my new 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
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
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
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 do I fix this?, Where can I get this file
33 matches
Mail list logo