r'
Cc: [EMAIL PROTECTED]
Subject: RE: White Space
Chris,
Another option is to use | instead of commas. Unless you have pipes in your
file. :)
Donny
> -Original Message-
> From: Dan Nelson [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 20, 2004 2:55 PM
> To: Chris
3:45 PM, Chris Fossenier wrote:
What is the best way to deal with white space in a mysql database?
What I'm talking about is trailing spaces in larger fields. We receive
data
in fixed width format, so when you import it, you get a bunch of
trailing
white spaces that take up space. Mul
On 20 Feb 2004 at 14:55, Dan Nelson wrote:
> If you need leading and trailing space stripped, you can postprocess
> the field with the TRIM() function.
But note that, unlike similar functions in some languages, the MySQL
TRIM() function removes spaces (ASCII 32 characters), not whitespace
(whic
Chris,
Another option is to use | instead of commas. Unless you have pipes in your
file. :)
Donny
> -Original Message-
> From: Dan Nelson [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 20, 2004 2:55 PM
> To: Chris Fossenier
> Cc: [EMAIL PROTECTED]
> Subject: Re:
In the last episode (Feb 20), Chris Fossenier said:
> What is the best way to deal with white space in a mysql database?
>
> What I'm talking about is trailing spaces in larger fields. We
> receive data in fixed width format, so when you import it, you get a
> bunch of traili
What is the best way to deal with white space in a mysql database?
What I'm talking about is trailing spaces in larger fields. We receive data
in fixed width format, so when you import it, you get a bunch of trailing
white spaces that take up space. Multiply these white spaces by 120mi
I am using MySQL (4.1.0-alpha-max-nt) on Windows 2000.
I'm trying to read a text file that looks a bit like this:
40 3 10 M000 ... 1000... ACBB... ...
where the ... indicate more characters. I've created the
following table to store this data
(
id int NOT NULL,
year INT NOT NULL
On Thu 2003-03-20 at 14:01:52 -0500, [EMAIL PROTECTED] wrote:
> I have a table with a column defined as the following.
>
> hash CHAR(16) BINARY NOT NULL
>
> Most data inserts fine. However, if data has trailing white space
> (ASCII character 32), it seems to be getting
I have a table with a column defined as the following.
hash CHAR(16) BINARY NOT NULL
Most data inserts fine. However, if data has trailing white space
(ASCII character 32), it seems to be getting truncated by MySQL during
the insert, such that subsequent queries to find the values fail. Full
>
>
>> I am trying to trim both leading and trailing whitespace from a TEXT
>> column in my SELECT query. I found the TRIM() command in the manual,
>> however, I can't get it to act upon a column name instead of an
>> actual string. Can anyone help?
>
>
> If you just say TRIM(col_name) it wil
On 7 Feb 2002, at 8:20, Richard Reina wrote:
> I tried both ideas and neither one removed the white spaces. arrr!
> :-(
Unfortunately TRIM doesn't remove whitespace (spaces, tabs, carriage
returns, linefeeds), as it does in some programming languages. It
just removes spaces, unless you specif
At 16:17 -0800 2/6/02, Richard Reina wrote:
>I am trying to trim both leading and trailing whitespace from a TEXT
>column in my SELECT query. I found the TRIM() command in the
>manual, however, I can't get it to act upon a column name instead of
>an actual string. Can anyone help?
If you jus
On 7 Feb 2002, at 8:20, Richard Reina wrote:
> I tried both ideas and neither one removed the white spaces. arrr!
> :-(
Unfortunately TRIM doesn't remove whitespace (spaces, tabs, carriage
returns, linefeeds), as it does in some programming languages. It
just removes spaces, unless you specif
>
>
>> I am trying to trim both leading and trailing whitespace from a TEXT
>> column in my SELECT query. I found the TRIM() command in the manual,
>> however, I can't get it to act upon a column name instead of an
>> actual string. Can anyone help?
>
>
> If you just say TRIM(col_name) it wil
At 16:17 -0800 2/6/02, Richard Reina wrote:
>I am trying to trim both leading and trailing whitespace from a TEXT
>column in my SELECT query. I found the TRIM() command in the
>manual, however, I can't get it to act upon a column name instead of
>an actual string. Can anyone help?
If you jus
I am trying to trim both leading and trailing whitespace from a TEXT
column in my SELECT query. I found the TRIM() command in the manual,
however, I can't get it to act upon a column name instead of an actual
string. Can anyone help?
Thanks,
Richard
--
16 matches
Mail list logo
