UNIQUE Column detects 'u' = 'ú'
Posted by: Fabricio Martinez
Date: July 29, 2006 09:53PM

I have this table:
CREATE TABLE `data` (
`id_data` int(10) unsigned NOT NULL auto_increment,
`data` varchar(255) character set utf8 collate utf8_spanish_ci NOT NULL default '',
`source` varchar(255) character set utf8 collate utf8_spanish_ci NOT NULL default '',
PRIMARY KEY (`id_data`),
UNIQUE KEY `U_DATA` (`data`),
KEY `I_DATA` (`data`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

and for some reason Im getting duplicate entry errors for entering 'Cu' and 'Cú'
How can I fix this?

Options: ReplyQuote


Subject
Views
Written By
Posted
UNIQUE Column detects 'u' = 'ú'
2844
July 29, 2006 09:53PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.