Harald Vajkonny napsal(a):
Ananda Kumar schrieb:
strange. did u exit and reconnect and did the select?
Yes, I tried it once more. I have to put the USE command before I change
session settings to "latin" to make it work without error (otherwise I
still get the duplicate message). But even after exiting I get the
national characters displayed as two (or more) bytes.
Try to convert file to latin1, if it's possible, create database with
latin1 charset, create table with required structure (you can set utf8
charset to string fields ) and then load data. What client do you use to
check whether data are OK? I can recommend MySQL Query Browser where I
don't have to care about setting charset and collation parameters.
HTH,
Dusan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]