Command line tool problem

[Catalin Borcea]

Hi,

I'm new to MySQL and I use MySQL-Shareware 3.22.34 on a NTWKS4.0-SP4 machine. When I work
with the MySQL command line tool(mysql.exe), if I issue a query to a table that contains
varchar fields, the output is mangled. Somehow, the output field length is smaller than
the actual size of the field and the last characters are written over the beginning
characters. The example below is more explicit:

###### Begin of screen capture ##########################
mysql> describe telefon_abonati;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| numar | varchar(30) |      | PRI |         |       |
| nume  | varchar(50) |      | MUL |         |       |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> select nume from telefon_abonati order by nume desc limit 10;
+-----------------------+
| nume                  |
+-----------------------+
  |VOLINSCHI VIRGINIA
 |ZVERGINSCHI GHEORGHE
        |RNELIA
        |RELIAN
           |
         |OSIF
         |OLAE
        |EZAREL
       |U VASILE
       |U VASILE
+-----------------------+
10 rows in set (0.73 sec)
###### End of screen capture ############################

the actual fields are:
ZVOLINSCHI VIRGINIA 
ZVERGINSCHI GHEORGHE
ZUZU CORNELIA
ZUZU AURELIAN
ZUZA EUGEN
ZUSKAN IOSIF
ZUPU NICOLAE
ZUGUN CEZAREL
ZUGRAVU VASILE
ZUGRAVU VASILE

Also, if I try to use concat on varchar fields the output is similarly mangled:

###### Begin of screen capture ##########################
mysql> select concat(nume,'123') from telefon_abonati order by nume desc limit 10;
+--------------------------+
| concat(nume,'123')       |
+--------------------------+
123  |INSCHI VIRGINIA
123 |RGINSCHI GHEORGHE
123        |LIA
123        |IAN
123           |
123         |F
123         |E
123        |REL
123       |ASILE
123       |ASILE
+--------------------------+
10 rows in set (0.73 sec)

mysql> select concat(nume,'123') from telefon_abonati order by nume desc limit 10
    -> ego
*************************** 1. row ***************************
123cat(nume,'123'): ZVOLINSCHI VIRGINIA
*************************** 2. row ***************************
123cat(nume,'123'): ZVERGINSCHI GHEORGHE
*************************** 3. row ***************************
123cat(nume,'123'): ZUZU CORNELIA
*************************** 4. row ***************************
123cat(nume,'123'): ZUZU AURELIAN
*************************** 5. row ***************************
123cat(nume,'123'): ZUZA EUGEN
*************************** 6. row ***************************
123cat(nume,'123'): ZUSKAN IOSIF
*************************** 7. row ***************************
123cat(nume,'123'): ZUPU NICOLAE
*************************** 8. row ***************************
123cat(nume,'123'): ZUGUN CEZAREL
*************************** 9. row ***************************
123cat(nume,'123'): ZUGRAVU VASILE
*************************** 10. row ***************************
123cat(nume,'123'): ZUGRAVU VASILE
10 rows in set (0.73 sec)
###### End of screen capture ############################

How can I solve this problem? It is very hard to debug my programs if I don't have a good,

quick query tool. I could write my own query tool but this would be very time-expensive
and 
I'm running out of time.


-- Catalin Borcea --