Hi

I'm loading csv data like so:

Code:
LOAD DATA 			
LOCAL INFILE '".$local."' 			
INTO TABLE `test3` 			
CHARACTER SET UTF8 			
FIELDS TERMINATED BY ',' 			
ENCLOSED BY '\"' 			
LINES TERMINATED BY '|' 			
(A,T)
My table is set to utf8_bin.

The code works fine most of the time. However, I'm finding that if the table already has Mon„e in it, new records aren't created for MonŠe or Monae if they are in the csv file.

I originally had a table that was utf8_unicode_ci, and the same thing happened. So I created the new utf8_bin table, as I thought it would be accent sensitive.

Anyone understand collation enough to see where I'm tripping up?

Thanks for your time and help.