Are you talking about display width? Use the RPAD function:
http://dev.mysql.com/doc/mysql/en/string-functions.html
mysql> SELECT RPAD('foo', 20, 'x') AS foo;
+--+
| foo |
+--+
| foox |
+--+
___
Dathan Pattishall wrote:
Use char
And use fixed-length types for *all* columns... one variable-length
column makes all records variable-length.
Nick
-Original Message-
From: Marc Michalowski [mailto:[EMAIL PROTECTED]
Sent: Friday, January 28, 2005 10:28 AM
To: mysql@lists.mysql.com
S
Use char
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: Marc Michalowski [mailto:[EMAIL PROTECTED]
> Sent: Friday, January 28, 2005 10:28 AM
> To: mysql@lists.mysql.com
> Subject: Fixed with Fields
>
> I was wondering if there is a way to
