Re: Importar datos desde csv a campos varchar
Hola Juan,
Trata creando tu tabla "temporal" de la siguiente manera:
DROP TABLE IF EXISTS `temporal`;
CREATE TABLE `temporal` (
`NOMBRE` varchar(40) character set latin1 default NULL,
`FACTURA` varchar(20) character set latin1 default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
Debes ser muy cuidadoso si vas a cambiar el juego de caracteres de tu servidor, esto puede traerte problemas con los datos ya almacenados, debes hacer un buen set de pruebas antes de hacer el cambio en tu servidor de producción.
Subject
Views
Written By
Posted
8718
June 13, 2007 05:23PM
3877
June 13, 2007 06:50PM
3994
June 14, 2007 12:36PM
3372
June 14, 2007 02:24PM
5320
June 14, 2007 02:45PM
5241
June 14, 2007 03:39PM
3043
June 14, 2007 03:59PM
Re: Importar datos desde csv a campos varchar
3120
June 14, 2007 05:12PM
2813
June 14, 2007 05:43PM
3359
June 14, 2007 06:08PM
3260
June 14, 2007 06:20PM
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.