db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Alvarado Murillo (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-7024) Aparece el caracter □ (UNICODE 25A1) al insertar datos DB
Date Thu, 27 Dec 2018 18:22:00 GMT

    [ https://issues.apache.org/jira/browse/DERBY-7024?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16729769#comment-16729769
] 

Jonathan Alvarado Murillo commented on DERBY-7024:
--------------------------------------------------

Hi, [~bryanpendleton] i have opencsv, i create the csv with txt, i save it like UTF-8, later
i read the lines, when i capture the data in the variable, it is good, like "Accounting",
i make System.out.println y de out is "Accounting", but when i make the insert, it saves
like "□Accounting", but only with the first, the CSV file doesn't have nothing on the first
line, i check it.

the SYSCS_UTIL.SYSCS_IMPORT_DATA system procedure, i doesnt work to me, because i have autonomeric
fields, so when i try to import, send me an error.

this is my code

// Creación de tabla de materias.
 String archivoMaterias = "C:\\TEJAM\\TBLMATERIAS.csv";
 CSVReader readerMaterias = new CSVReader(new BufferedReader(new InputStreamReader(new FileInputStream(archivoMaterias),"UTF-8")));
 String[] nextLineMaterias;
 while ((nextLineMaterias = readerMaterias.readNext()) != null) { 
 String agregarMaterias="insert into APP.TBLMATERIAS VALUES(default,'"+nextLineMaterias[0]+"')";
 this.ejecutar(agregarMaterias);
 }
 

> Aparece el caracter □ (UNICODE 25A1) al insertar datos DB
> ---------------------------------------------------------
>
>                 Key: DERBY-7024
>                 URL: https://issues.apache.org/jira/browse/DERBY-7024
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.14.2.0
>            Reporter: Jonathan Alvarado Murillo
>            Priority: Major
>
> Hola, tengo datos en un archivo CSV, cuando inserto una línea como insert into APP.TBLMATERIAS
VALUES(default,'Accounting.'), en la salida del NetBeans está bien, pero al momento de insertarse
en la DB me escribe un caracter □ (UNICODE 25A1), por lo tanto mi registro queda □Accounting.,
pero ese caracter no está en la captura de datos del archivo CSV ni en la salida de NetBeans
al hacer el System.out.Print, lo curioso es que sólo lo hace con el primer registro, los
otros registros los inserta correctamente sin ese caracter, esto es un error grave para mi
app porque uso ese dato para una consulta y ejecutar una acción.
> Hello, I have data in a CSV file, when I insert a line as "insert into APP.TBLMATERIAS
VALUES (default, 'Accounting.')", In the output of NetBeans it is fine, but at the moment
of inserting itself into the DB it writes me a character □ (UNICODE 25A1), therefore my
record remains "□ Accounting.", But that character is not in the data capture of the CSV
file or in the output of NetBeans when doing the System.out.Print, the funny thing is that
only do with the first record, the other records insert them correctly without that character,
this is a serious error for my app because I use that field for a query and execute an action.
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message