apostrophe char problem

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

Re: apostrophe char problem

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

RE: apostrophe char problem

- 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.0.53 on FreeBSD5.3 I add any text as data with phpadmin on web

CHAR problem ...

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

Re: CHAR problem ...

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 VARCHAR. Is

Re: CHAR problem ...

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.

Re: CHAR problem ...

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`

Re: CHAR problem ...

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 bug? We are

VARCHAR/CHAR problem

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)

Re: VARCHAR/CHAR problem

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

char() problem

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?

Re: char() problem

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'. But