zipzipziping wrote:

> 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??

Look at the documentaion. ISO-8859-1 is for all European langs.
DE_DE is more German specific.

>
>
> 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.
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

--
Lev Assinovsky Peterlink Web
Programmer St. Petersburg, Russia
Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7�
E-mail: lev@...




[Non-text portions of this message have been removed]