Ooks Server [EMAIL PROTECTED] wrote:
I've run into a problem with the behavior of concat(). If I have two fields,
char(10), and I do this:
concat(field1,fields)
With MSSQL I get both fields including trailing spaces. With MYSql, I get
the two fields with the trailing spaces trimmed.
]
Subject: Re: concat() differences between mssql and mysql
Ooks Server [EMAIL PROTECTED] wrote:
I've run into a problem with the behavior of concat(). If I
have two fields,
char(10), and I do this:
concat(field1,fields)
With MSSQL I get both fields including trailing spaces
]
Subject: concat() differences between mssql and mysql
I've run into a problem with the behavior of concat(). If I
have two fields,
char(10), and I do this:
concat(field1,fields)
With MSSQL I get both fields including trailing spaces. With
MYSql, I get
the two fields with the trailing
-Original Message-
From: Ooks Server [mailto:[EMAIL PROTECTED]
Sent: Monday, July 07, 2003 4:38 PM
To: [EMAIL PROTECTED]
Subject: concat() differences between mssql and mysql
I've run into a problem with the behavior of concat(). If I
have two fields,
char(10), and I do this:
concat
I've run into a problem with the behavior of concat(). If I have two fields,
char(10), and I do this:
concat(field1,fields)
With MSSQL I get both fields including trailing spaces. With MYSql, I get
the two fields with the trailing spaces trimmed. Example:
Field1 = abc
Field2 = qwerty