Some UTF-8 observations

[Kem Tekinay]

I modified the Valentina example that I wrote for my Data-On-Demand ListBox
to use UTF-8, and immediately discovered two things:

First, the size of the database is not appreciably smaller. After importing
over 5 million records of 7 fields (3 indexed strings, 4 non-indexed
doubles), the size of the files was reduced to just under 700 MB from 766
MB.

Second, searches do not work correctly when using UTF-8. I got no or strange
results when I used StartsWith searches on the indexed strings. For example,
the following statement in Studio should yield one record:

select Zip_Codes.Zip_Code, city from Zip_Codes where city like 'mount kisc%'

This works fine on the UTF16 version.

__________________________________________________________________________
Kem Tekinay                                                 (212) 201-1465
MacTechnologies Consulting                              Fax (914) 242-7294
http://www.mactechnologies.com                        Pager (917) 491-5546

  To join the MacTechnologies Consulting mailing list, send an e-mail to:
           mactechnologies_consulting-subscribe at yahoogroups.com







-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina-beta/attachments/20061110/b885e441/attachment.html