MySQL Forums
Forum List  »  Newbie

Charset issues
Posted by: aeron glemann
Date: May 10, 2005 03:27PM

Hi!

I am having problems importing data via LOAD DATA INFILE into a table and having special characters preserved. I upgraded from MySQL 3.x to 4.0 - that was sorta painful so I haven't gone all the way to 4.1 yet. The table according to myisamchk is 'Character set: latin1 (8)' - The data is ASCII using 'Windows Arial character set' - i'm not sure if Windows Arial is a character set or a font though :)

Basically after I execute LOAD DATA INFILE the data appears with all special characters as '?' for example:

| Ab?ch?
| Ab?jar
| Abejorral
| Ab?nakis
| Abenberg
| Aben?jar

What the heck do I need to do to get the special characters to import/display?

Running MySQL 4.024ish on Fedora Linux - any help would be super appreciated!!

Options: ReplyQuote


Subject
Written By
Posted
Charset issues
May 10, 2005 03:27PM
May 10, 2005 05:36PM


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.