You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by RAPPAZ Francois <fr...@unifr.ch> on 2009/10/28 15:40:37 UTC
ij run and utf8 file
I have a file with sql commands: The file is encoded in utf8. I have put "derby.ui.codeset=utf8" in my derby.properties file in the derby system directory.
When I load ij with
U:\docs\jprog\derby>java -jar %DERBY_HOME%/lib/derbyrun.jar ij -p ij.properties
And try to run the command in my file, I get
ij> ´╗┐insert into authors (name1, name2, data) values ('Abarca', 'Carolina', 'Abarca, Carolina 2');
ERREUR 42X02 : Lexical error at line 1, column 2. Encountered: "\u00bb" (187),
after : "".
Any idea what I'm missing ?
Thanks
François
RE: ij run and utf8 file
Posted by RAPPAZ Francois <fr...@unifr.ch>.
Thanks a lot ! that was it: with the "derby.ui.codeset=utf8" line in ij.properties file, the sql commands were done without problem.
François
> -----Original Message-----
> From: Knut.Hatlen@Sun.COM [mailto:Knut.Hatlen@Sun.COM]
> Sent: jeudi, 29. octobre 2009 10:40
> To: Derby Discussion
> Subject: Re: ij run and utf8 file
>
> RAPPAZ Francois <fr...@unifr.ch> writes:
>
> > I have a file with sql commands: The file is encoded in utf8. I have
> put "derby.ui.codeset=utf8" in my derby.properties file in the derby
> system directory.
> > When I load ij with
> > U:\docs\jprog\derby>java -jar %DERBY_HOME%/lib/derbyrun.jar ij -p
> ij.properties
> >
> > And try to run the command in my file, I get
> > ij> ´╗┐insert into authors (name1, name2, data) values ('Abarca',
> 'Carolina', 'Abarca, Carolina 2');
> > ERREUR 42X02 : Lexical error at line 1, column 2. Encountered:
> "\u00bb" (187),
> > after : "".
> >
> > Any idea what I'm missing ?
>
> Hi François,
>
> The derby.properties file is only read by the Derby engine and not by
> tools like ij, and since derby.ui.codeset is a tools property, setting
> it there wouldn't help. Since you start ij with -p ij.properties, it
> should be fine if you put the property setting in ij.properties.
>
> If it still doesn't work, is there any chance that the line that causes
> the error starts with a "»" character?
>
> --
> Knut Anders
Re: ij run and utf8 file
Posted by Knut Anders Hatlen <Kn...@Sun.COM>.
RAPPAZ Francois <fr...@unifr.ch> writes:
> I have a file with sql commands: The file is encoded in utf8. I have put "derby.ui.codeset=utf8" in my derby.properties file in the derby system directory.
> When I load ij with
> U:\docs\jprog\derby>java -jar %DERBY_HOME%/lib/derbyrun.jar ij -p ij.properties
>
> And try to run the command in my file, I get
> ij> ´╗┐insert into authors (name1, name2, data) values ('Abarca', 'Carolina', 'Abarca, Carolina 2');
> ERREUR 42X02 : Lexical error at line 1, column 2. Encountered: "\u00bb" (187),
> after : "".
>
> Any idea what I'm missing ?
Hi François,
The derby.properties file is only read by the Derby engine and not by
tools like ij, and since derby.ui.codeset is a tools property, setting
it there wouldn't help. Since you start ij with -p ij.properties, it
should be fine if you put the property setting in ij.properties.
If it still doesn't work, is there any chance that the line that causes
the error starts with a "»" character?
--
Knut Anders
RE: ij run and utf8 file
Posted by RAPPAZ Francois <fr...@unifr.ch>.
That the BOM add by notepad, the things to do was putting the codeset properties in the ij.properties file as suggested by Knut
François
> -----Original Message-----
> From: Bernt.Johnsen@Sun.COM [mailto:Bernt.Johnsen@Sun.COM]
> Sent: jeudi, 29. octobre 2009 10:41
> To: Derby Discussion
> Subject: Re: ij run and utf8 file
>
> >>>>>>>>>>>> RAPPAZ Francois wrote (2009-10-28 15:40:37):
> > I have a file with sql commands: The file is encoded in utf8. I have
> put "derby.ui.codeset=utf8" in my derby.properties file in the derby
> system directory.
> > When I load ij with
> > U:\docs\jprog\derby>java -jar %DERBY_HOME%/lib/derbyrun.jar ij -p
> > ij.properties
> >
> > And try to run the command in my file, I get
> > ij> ´╗┐insert into authors (name1, name2, data) values ('Abarca',
> > ij> 'Carolina', 'Abarca, Carolina 2');
> > ERREUR 42X02 : Lexical error at line 1, column 2. Encountered:
> > "\u00bb" (187), after : "".
> >
> > Any idea what I'm missing ?
>
> The two characters before the insert?
>
> >
> > Thanks
> > François
>
> --
> Bernt Marius Johnsen, Staff Engineer
> Database Technology Group, Sun Microsystems, Trondheim, Norway
Re: ij run and utf8 file
Posted by "Bernt M. Johnsen" <Be...@Sun.COM>.
>>>>>>>>>>>> RAPPAZ Francois wrote (2009-10-28 15:40:37):
> I have a file with sql commands: The file is encoded in utf8. I have put "derby.ui.codeset=utf8" in my derby.properties file in the derby system directory.
> When I load ij with
> U:\docs\jprog\derby>java -jar %DERBY_HOME%/lib/derbyrun.jar ij -p ij.properties
>
> And try to run the command in my file, I get
> ij> ´╗┐insert into authors (name1, name2, data) values ('Abarca', 'Carolina', 'Abarca, Carolina 2');
> ERREUR 42X02 : Lexical error at line 1, column 2. Encountered: "\u00bb" (187),
> after : "".
>
> Any idea what I'm missing ?
The two characters before the insert?
>
> Thanks
> François
--
Bernt Marius Johnsen, Staff Engineer
Database Technology Group, Sun Microsystems, Trondheim, Norway