In article <1194342367.999671.27790@[EMAIL PROTECTED]
>,
razvanprodana@[EMAIL PROTECTED]
wrote:
> On 19 Okt., 17:29, Andrew Clay <a...@[EMAIL PROTECTED]
> wrote:
> > In article <1192797746.362900.168...@[EMAIL PROTECTED]
>,
> >
> > razvanprod...@[EMAIL PROTECTED]
wrote:
> > > Hi,
> >
> > > Is any possibility in CodeBase to create an index on an Unicode
field?
> >
> > > N. Prodana
> >
> > I haven't tried it, but there seems to be some source code for it in
the
> > Codebase code.
>
> Hi,
>
> Of course, I tried to change the source code but it looks very
> complicated because the expressions don't sup****t the unicode type.
> By example, I need to define an index like: "STRW(ID_LANGUAGE, 5,
> 0)+SUBSTRW(TEXT, 0, 100)" where ID_LANGUAGE is a numerical field and
> the TEXT is a unicode field.
> An expression like "STR(ID_LANGUAGE, 5, 0)+SUBSTR(TEXT, 0, 100)" is
> not useful because converts the unicode text into an ANSI text.
>
> Maybe I'm trying to find a solution on a wrong direction. Any other
> ideas?
>
> N. Prodana
That wasn't the question you originally asked. STR and SUBSTR do not
produce Unicode output, so yes I imagine you'll have to write the extra
functions you need. Sorry I can't be of more help.
Andy.
--
Andrew Clay
|
