Can anyone recommend a database engine which meets these requirements:

* Unicode (WideString) support, including the ability to search WideString
fields

* VCL-based with source (no external DLLs)

* Works with ExpressQuantumGrid

FWIW, I was hoping to use DBISAM, but it doesn't appear to support
WideString fields.

Thanks,
---
Nick Bradbury
TopStyle CSS/HTML Editor
FeedDemon RSS Reader
http://www.bradsoft.com

> Thanks, Trev - that's very helpful.  I wasn't aware of this limitation in
> Delphi.  Given this, perhaps I should store the data as UTF-8 instead.
That
> way I could treat it like an AnsiString when necessary for filtering, etc.

Unicode is supported in NexusDB SQL if you use Params instead of directly
specifying string literals in the SQL text.

In the future (read: not in v1) we plan to support filters for TnxTable that
use the SQL engine WHERE evaluation engine. If we add either Params support
for this SQL based filter or a Unicode enabled SQL parser this would solve
all problems related to using Unicode in filters.

If you decide to use NexusDB I'm more than happy to work with you on any
Unicode / internationalization related issues you may encounter.

-- 
Thorsten Engler [NexusDB Architect]

Thanks, Trev - that's very helpful.  I wasn't aware of this limitation in
Delphi.  Given this, perhaps I should store the data as UTF-8 instead.  That
way I could treat it like an AnsiString when necessary for filtering, etc.
---
Nick Bradbury
TopStyle CSS/HTML Editor
FeedDemon RSS Reader
http://www.bradsoft.com

"Trev"  wrote in message
news:3f560641$1@newsgroups.borland.com...
> "nxtWideString and nxtWideChar fields are supported. They both map to
> TWideStringFields in Delphi.
>
> Unicode string literals are currently not supported in SQL and text
Filters.
> (SQL queries are specified in a TStringList which doesn't support Unicode.
> The basic parser for filter strings is written by Borland in dbcommon.pas
> and doesn't support Unicode)"
> Thorsten Engler [NDA]
>
> HTH
> Trev

"nxtWideString and nxtWideChar fields are supported. They both map to
TWideStringFields in Delphi.

Unicode string literals are currently not supported in SQL and text Filters.
(SQL queries are specified in a TStringList which doesn't support Unicode.
The basic parser for filter strings is written by Borland in dbcommon.pas
and doesn't support Unicode)"
Thorsten Engler [NDA]

HTH
Trev

"Brian Moelk"  wrote in message
news:3f55edad$1@newsgroups.borland.com...
> > Can anyone recommend a database engine which meets these requirements:
> >
> > * Unicode (WideString) support, including the ability to search
WideString
> > fields
> >
> > * VCL-based with source (no external DLLs)
> >
> > * Works with ExpressQuantumGrid
>
> NexusDB meets all of your criteria.
>
> --
> Brian Moelk
> bmoelk@NObrainendeavorSPAM.FORcomME
> http://www.brainendeavor.com
>
>

Nick Bradbury (TopStyle/FeedDemon) wrote:

> According to messages in their forums, DBISAM doesn't support WideString
> fields.  Are you using WideStrings with DBISAM?

Kind of. When I was testing Unicode support for ElPack, I got DBISAM 
tables from customers and ElPack controls seemed to find WideString 
fields. The trick is to set the language to something non-English for 
the field (or table? Don't remember).

-- 
Eugene Mayevski
EldoS Corp., CTO
Security and networking solutions
http://www.eldos.com

"Brian Moelk" wrote:
> NexusDB meets all of your criteria.

NexusDB certainly looks good.  Are you currently using it, and if so, have
you used it with WideString fields?

Thanks,
---
Nick Bradbury
TopStyle CSS/HTML Editor
FeedDemon RSS Reader
http://www.bradsoft.com

"Eugene Mayevski" wrote:
> > FWIW, I was hoping to use DBISAM, but it doesn't
> > appear to support WideString fields.
>
> It does. However Unicode support there is quite strange. I think you
> need to contact their support directly.

Thanks - I'll do that.

According to messages in their forums, DBISAM doesn't support WideString
fields.  Are you using WideStrings with DBISAM?
---
Nick Bradbury
TopStyle CSS/HTML Editor
FeedDemon RSS Reader
http://www.bradsoft.com

> Can anyone recommend a database engine which meets these requirements:
>
> * Unicode (WideString) support, including the ability to search WideString
> fields
>
> * VCL-based with source (no external DLLs)
>
> * Works with ExpressQuantumGrid

NexusDB meets all of your criteria.

--
Brian Moelk
bmoelk@NObrainendeavorSPAM.FORcomME
http://www.brainendeavor.com

Nick Bradbury (TopStyle/FeedDemon) wrote:

> FWIW, I was hoping to use DBISAM, but it doesn't appear to support
> WideString fields.

It does. However Unicode support there is quite strange. I think you 
need to contact their support directly.

-- 
Eugene Mayevski
EldoS Corp., CTO
Security and networking solutions
http://www.eldos.com