sorting w accents

Ruslan Zasukhin sunshine at public.kherson.ua
Wed Jun 15 08:57:01 CDT 2005


On 6/13/05 3:39 PM, "John W. Miescher" <miescher at bizdata.com> wrote:

> Hi Ruslan,
> attached is the sample project. 1. Create the DB, 2. run a query.
>  
> using the prefab '%fred%' finds nothing, but '%fréd%' finds 3 records.
>  
> Both are wrong - the should find Frédérik, not more and not less.
>  
> Hope you can debug me. Best regards, john m.
>  
> E: miescher at bizdata.com

Hi John,

Simple.

You have to use UTF8 for storage encoding.
Not works now.

I have replace to
      mDB_UTF8 = CreateDatabase( "UTF16" )
  
And query works as you expect -- one record Frédérik is found
  

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]




More information about the Valentina mailing list