Re: varchar problem

I noticed that Message-ID: <42b378b7$1_1@xxxxxxxxxxxxxxxxxxxxxxxxx> from
Terry contained the following:

>I apparently do not correctly understand varchar - everything I have
>read indicates that text entered into a MySQL table with varchar
>characteristics will automatically have any space characters stripped
>from both ends of the line.

Where have you read that? A space is just another character. If you
want to strip them, use trim().

--
Geoff Berrow 0110001001101100010000000110
001101101011011001000110111101100111001011
100110001101101111001011100111010101101011
.

Relevant Pages

  • Re: Inserting an Email Address fails.
    ... 'Position' VARCHAR NOT NULL, ... "You have an error in your SQL syntax. ... corresponds to your MySQL server version for the right syntax to use ...
    (perl.dbi.users)
  • HELP: moving DB to another server probs :(
    ... Upon importing into the new MySQL server I get this error messsage. ... I had a look at MySQL website but to no avail I still did not know what ... filepath varchar(255) NOT NULL, ...
    (microsoft.public.sqlserver.programming)
  • Re: varchar problem
    ... >>>read indicates that text entered into a MySQL table with varchar ... >Heading "Char vs. Varchar" ... about CHAR datatypes - the CHAR datatype PADs with spaces. ... Query OK, ...
    (alt.php)
  • Re: checkbox values stored in mysql
    ... you need to review the MySQL docs concerning the CHAR/VARCHAR data types at: ... There is a table that shows what the difference between CHAR and VARCHAR - read ... Whoever gave you that sage advice obviously should not be designing databases. ... MySQL and PostgreSQL are fine for some ...
    (comp.lang.php)
  • MYSQL - PHP
    ... First of all sorry if this is not the correct newsgroup for this question, ... but I am using PHP with MYSQL and someone here could have an answer and the ... bak_content_title varchar ...
    (comp.lang.php)