Hi Luc.

its a java app, and i use jdbc 2.01.
my default charset is NONE(at db)
do i understand this right: with none im not able to pass üöä.
if so is there a chance to change to default charset for example
with backup/restore?
and is charset ISO-8859-1 the charset of choice in germany??

thanks for your help

fb.

--- In ib-support@y..., Lucas Franzen <luc@r...> wrote:
>
>
> Lev Assinovsky schrieb:
> >
> > First of all 'containing' is case sensitive.
>
> No, it is case insensitive!
> "Like", "starting with" etc are case sensitive, but "containing" is
not.
>
> > THe solution (I assume your search word <WORD>
> > in column <COL> and your character set is <CHARSET>):
> > select ... where UPPER(<COL> collate <CHARSET>) containing UPPER
(<WORD>
> > collate <CHARSET>)
>
> > > executing a select statement with containing clausel:
> > > select * from land where name containing 'öste'
> > > returns 0 rows, but there is a row with the name=Österreich
> > >
> > > All other character working fine, for example:
> > > select * from land where name containing 'deu'
> > > returns 1 row with name=Deutschland
> > >
>
>
> How do you do the selet?
> From an application?
> If so, make sure that your connection has the right charcter set
> defined.
> If you have (for example) character set NONE, you can't pass Umlaute
> (äöü...) to your database.
>
> HTH
> Luc.