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: [email protected] [mailto:[email protected]] > 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
