<HTML>
<HEAD>
<TITLE>Some UTF-8 observations</TITLE>
</HEAD>
<BODY>
<FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:14.0px'>I modified the Valentina example that I wrote for my Data-On-Demand ListBox to use UTF-8, and immediately discovered two things:<BR>
<BR>
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.<BR>
<BR>
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:<BR>
<BR>
</SPAN></FONT><FONT SIZE="2"><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:12.0px'><B>select Zip_Codes.Zip_Code, city from Zip_Codes where city like 'mount kisc%'<BR>
<BR>
</B></SPAN></FONT></FONT><FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:14.0px'>This works fine on the UTF16 version.<BR>
</SPAN></FONT><FONT SIZE="2"><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:12.0px'><BR>
__________________________________________________________________________<BR>
Kem Tekinay (212) 201-1465<BR>
MacTechnologies Consulting Fax (914) 242-7294<BR>
<a href="http://www.mactechnologies.com">http://www.mactechnologies.com</a> Pager (917) 491-5546<BR>
</SPAN></FONT></FONT><FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:14.0px'><BR>
</SPAN></FONT><FONT SIZE="2"><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:12.0px'><I>To join the MacTechnologies Consulting mailing list, send an e-mail to:<BR>
</I> mactechnologies_consulting-subscribe@yahoogroups.com
</SPAN></FONT></FONT>
<P ALIGN=CENTER>
<FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:14.0px'><BR>
<BR>
<BR>
<BR>
</SPAN></FONT>
<P>
<FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:14.0px'><BR>
</SPAN></FONT>
</BODY>
</HTML>