Hi,

At November 26, 2003, 18:19, Miles Dymott wrote:

> Does anyone know if it is possible to do select statements on
> UNICODE_FSS varchar fields without using a parametised query.
> I need to use STARTING WITH and BETWEEN. It doesn't work for strings
> longer than one character even if they are english characters.

I don't have a problem using UNICODE_FSS varchar fields in conjunction
with STARTING WITH. Are you connecting to the database using
UNICODE_FSS as the character set?

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)