> -Original Message-
> From: Halid Faith [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 02, 2006 11:51 AM
> To: mysql@lists.mysql.com
> Subject: apostrophe char problem
>
> Hello
>
> I use mysql 4.1.16 and php4.3.10 and phpmyadmin2.7 and
> apache-2
Something is double escaping the strings.
Check if GPC magic string is enabled (apache's auto escaping).
Also check if your code manually escapes the strings.
Halid Faith wrote:
Hello
I use mysql 4.1.16 and php4.3.10 and phpmyadmin2.7 and apache-2.0.53 on
FreeBSD5.3
I add any text as data wit
Hello
I use mysql 4.1.16 and php4.3.10 and phpmyadmin2.7 and apache-2.0.53 on
FreeBSD5.3
I add any text as data with phpadmin on web. it works well. But I have a
problem.
As example if I add a text to mysql table with phpadmin.
My text contains as below;
"Halid 's car is expensive"
I will see a
At 13:56 22.03.2004, Martijn Tonies wrote:
> > I have some problmes with MySQL. We have some CHAR columns, which after
> > CREATE or ALTER TABLE
> >
> > ALTER TABLE `traffic_stat` CHANGE `media_file_class_id`
> > `media_file_class_id` CHAR(32) NOT NULL
> >
> > will be VARCHAR. Is this an MySQL bu
thx.
At 13:43 22.03.2004, [EMAIL PROTECTED] wrote:
Rafal Kedziorski <[EMAIL PROTECTED]> wrote on 22/03/2004 12:36:33:
> hi,
>
> I have some problmes with MySQL. We have some CHAR columns, which after
> CREATE or ALTER TABLE
>
> ALTER TABLE `traffic_stat` CHANGE `media_file_class_id`
> `med
> > I have some problmes with MySQL. We have some CHAR columns, which after
> > CREATE or ALTER TABLE
> >
> > ALTER TABLE `traffic_stat` CHANGE `media_file_class_id`
> > `media_file_class_id` CHAR(32) NOT NULL
> >
> > will be VARCHAR. Is this an MySQL bug? We are using MySQL 4.0.18.
>
> http://ww
Rafal Kedziorski <[EMAIL PROTECTED]> wrote on 22/03/2004 12:36:33:
> hi,
>
> I have some problmes with MySQL. We have some CHAR columns, which after
> CREATE or ALTER TABLE
>
> ALTER TABLE `traffic_stat` CHANGE `media_file_class_id`
> `media_file_class_id` CHAR(32) NOT NULL
>
> will be VAR
hi,
I have some problmes with MySQL. We have some CHAR columns, which after
CREATE or ALTER TABLE
ALTER TABLE `traffic_stat` CHANGE `media_file_class_id`
`media_file_class_id` CHAR(32) NOT NULL
will be VARCHAR. Is this an MySQL bug? We are using MySQL 4.0.18.
Regards,
Rafal
--
MySQL General
At 15:39 +0200 3/4/02, savaidis wrote:
>I give this query:
>
>ALTER TABLE `companies` ADD `Tel3` CHAR(30) BINARY
>
>but it creates tel3 as VARCHAR(30) !
You have other variable-length columns in your table.
http://www.mysql.com/doc/S/i/Silent_column_changes.html
>
>Why?
>
>Makis
I give this query:
ALTER TABLE `companies` ADD `Tel3` CHAR(30) BINARY
but it creates tel3 as VARCHAR(30) !
Why?
Makis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.
(compatible; MSIE 5.0; Windows 98; DigExt)
Remote Address: 192.168.0.5
__
>From: "Chris Bolt" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Subject: RE: integer&char problem
>Date: Wed, 8 Aug 2001
(compatible; MSIE 5.0; Windows 98; DigExt)
Remote Address: 192.168.0.5
__
- Original Message -
From: Chris Bolt <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 2:15 PM
Subject: RE: integer&
> i have a problem in query. My field type is integer.
> The table is empty and i want to select max number from the
> field but it display error message.Then i try to change the type
> to char ,it's can but,
> the max is until 9 only.is there anyone can help me.
What query? What table? What er
hai ,
i have a problem in query. My field type is integer.
The table is empty and i want to select max number from the field but it display
error message.Then i try to change the type to char ,it's can but,
the max is until 9 only.is there anyone can help me.
thanks in advance
On Fri, 1 Jun 2001, Toth Dalibor wrote:
> I really need to know this: I have a column defined as char(2), default
> 'no', not null.
> When I create new entry into the table, I skip entering value into mentioned
> column
> because I expect to be filled with the default value, that is 'no'. Bu
database,sql,query
Hi!
I really need to know this: I have a column defined as char(2), default
'no', not null.
When I create new entry into the table, I skip entering value into mentioned
column
because I expect to be filled with the default value, that is 'no'. But that
doesn't happen!
Why?
Tha
16 matches
Mail list logo
