Character set/Collation problem in MySQL 4.1
Posted by: Mariela Mayorga
Date: January 17, 2005 01:23PM

Hi,
I'm having problems with character sets and collations in MySQL 4.1.
The problem is that when I execute the LOAD DATA INFILE command or when I export a table content to a CSV file, the characters like 'á', 'é', 'í', 'ó', 'ú', 'ñ'... are changed to things like 'ñ', 'ó',...
The charset variables values I have are:
character_set_client utf8
character_set_connection latin1
character_set_database utf8
character_set_results utf8
character_set_server latin1
character_set_system utf8

collation_connection latin1_spanish_ci
collation_database utf8_spanish_ci
collation_server latin1_swedish_ci

I´ll appreciate any help!!!

Options: ReplyQuote


Subject
Views
Written By
Posted
Character set/Collation problem in MySQL 4.1
6977
January 17, 2005 01:23PM


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.