Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Unicode field in DBISAM
Wed, Aug 20 2008 2:18 PMPermanent Link

Michael Higgins
I need just one string field in unicode. However, it has to be
searchable, indexable and respond to SQL. Is there a way to do this in
DBISAM, or do I have to bite the bullet and convert the whole thing to a
new database system?

Michael
Thu, Aug 21 2008 12:52 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Michael,

<< I need just one string field in unicode. However, it has to be
searchable, indexable and respond to SQL. Is there a way to do this in
DBISAM, or do I have to bite the bullet and convert the whole thing to a new
database system? >>

Unfortunately DBISAM does not support Unicode at all.  You can get around
this by using a binary field and interpreting the data yourself with custom
engine functions, but they won't be optimizable in SQL due to the required
function calls and will require some work to make it all functional.

Have you considered trying to just use a normal string field with multi-byte
characters ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Image