Hello, I have a table with 3 columns:
mysql> desc srv_ref_cities; +------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | state_id | char(2) | YES | | NULL | | | COUNTYCODE | char(3) | | | | | | CITY | varchar(40) | | | | | +------------+-------------+------+-----+---------+-------+ And the problem is when i display a query (two of the columns don't show): mysql> select * from srv_ref_cities where state_id='08'; +----------+------------+----------------------------+ | state_id | COUNTYCODE | CITY | +----------+------------+----------------------------+ | | Acres Green | | Aguilar if I have just state_id, countycode it displays just fine. I am thinking that maybe the city is unicode but i can't figure this one out. Has anyone else run into this problem or does anyone have any ideas to help me debug this? I have tried versions 4.0.15 and 5 but the same thing happens in each version. thanks, will -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]