Subject | Re: Problem in Bulk Insertion in Firebird |
---|---|
Author | Manish Lal Joshi |
Post date | 2007-02-22T11:57:25Z |
Dear Alan,
each line in my file consists of char[19+256]
19 for LONG value and 256 for CHAR(256)
Those nulls were all due to this:
Here is a snippit of my code.
long value=10;
string key="this is firebird forum";
not to dump this in my file
i did it like this:
char[] totalArray = new char[266];
value.ToString().ToCharArray().CopyTo(totalArray, 0);
char[] word = p.changeToASCII(files[i]);
word.CopyTo(totalArray, 10);
documentWriter.WriteLine(totalArray);
so there will be null chars present in the unfilled section of char array.
Like this i dumped in the file and then used as EXTERNAL FILE.
Hey i even dont know if i'm doing it all right or not..
Please do help me..
> I suppose you realise that external files need to be fixed fieldlength char
> files only?Yes i know that, i dumped my things into file like this:
each line in my file consists of char[19+256]
19 for LONG value and 256 for CHAR(256)
> You are talking about \0 (nulls) - I don't suppose you are imaginingthat
> any old file format is suitable to use as an external file?No, i havent used any old format of file.
Those nulls were all due to this:
Here is a snippit of my code.
long value=10;
string key="this is firebird forum";
not to dump this in my file
i did it like this:
char[] totalArray = new char[266];
value.ToString().ToCharArray().CopyTo(totalArray, 0);
char[] word = p.changeToASCII(files[i]);
word.CopyTo(totalArray, 10);
documentWriter.WriteLine(totalArray);
so there will be null chars present in the unfilled section of char array.
Like this i dumped in the file and then used as EXTERNAL FILE.
Hey i even dont know if i'm doing it all right or not..
Please do help me..