charset problem when loading data
Posted: Tue Mar 06, 2007 2:36 am
hi
i have de following problem:
i have a database in utf8-general_ci charset, i have to fill it with some data from other database
in the other database i have tables with data using characters like Ñ and they stored well in database
when i do select * into outfile ......, it creates a file that´s ok
when i try to load this file in my utf8 database i receive a message: "Data too long for column col1"
on the other hand , i have another pc with ubuntu and mysql, when i do select * into outfile. it creates a file similar to the first
but when i do "load data infile ...." with this file it uploads correct data with no problem
i opened both files and they are similar, how can i resolve this :O
i have de following problem:
i have a database in utf8-general_ci charset, i have to fill it with some data from other database
in the other database i have tables with data using characters like Ñ and they stored well in database
when i do select * into outfile ......, it creates a file that´s ok
when i try to load this file in my utf8 database i receive a message: "Data too long for column col1"
on the other hand , i have another pc with ubuntu and mysql, when i do select * into outfile. it creates a file similar to the first
but when i do "load data infile ...." with this file it uploads correct data with no problem
i opened both files and they are similar, how can i resolve this :O