Character set/Collation problem in MySQL 4.1
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!!!
Subject
Views
Written By
Posted
Character set/Collation problem in MySQL 4.1
6977
January 17, 2005 01:23PM
2744
January 20, 2005 02:12AM
2794
March 02, 2005 07:42AM
2885
April 02, 2005 01:18PM
2691
April 06, 2005 07:38AM
2106
November 01, 2006 04:20AM
2381
May 21, 2005 11:34AM
2359
August 03, 2005 04:46PM
2088
November 07, 2006 12:34AM
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.