I've inserted the following currecy sumbols in my table (structure mentioned below). All symbols are displayed properly when I do select, expect for the Euro symbol, which just shows a question mark (?). Any idea why is it behaving like that? I am using MySQL 4.0.17 on Windows XP Pro. My production server is Linux based. +----------+--------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------------------------+------+-----+---------+-------+ | CYRANK | decimal(3,0) unsigned zerofill | | | 999 | | | CYSYMBOL | varchar(5) | YES | | | | | CYNAME | varchar(50) | | | | | | CYCODE | char(3) | | PRI | | | +----------+--------------------------------+------+-----+---------+-------+
Test to use varchar(5) binary field type for CYSYMBOL field (if you store symbols here). Petr Vileta, Czech republic -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
