[
https://issues.apache.org/jira/browse/DERBY-7024?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16729075#comment-16729075
]
Bryan Pendleton commented on DERBY-7024:
----------------------------------------
How did you get the data from the CSV file into the INSERT statement? Did you
cut-and-paste it? Did you write a program to parse the CSV file? Did you use
SYSCS_IMPORT_DATA?
(https://db.apache.org/derby/docs/10.14/ref/rrefimportdataproc.html) Can you
share any more details about the code you wrote or the overall process you used?
If the problem was only on the first row of data, then perhaps your CSV file
has a line of column headers; you can delete the first line from your CSV file
and then try again?
> 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)
