[V4RB] SQL Queries/RB5.1/Unicode

[jda]

>Hi,
>
>I have tried both methods unsuccessfully. The query works fine as 
>long as the queried valentina vvarchar field doesn't contain any 
>accented characters. For example one record contains the word 
>'metá'. If you look for records containing 'met' velentina returns a 
>cursor with the correct record. If you then look for 'metá', 
>resulting cursor comes empty. Both words 'met' and 'metá' are taken 
>from an edit field. There is no change if I try to convert from UTF8 
>to MacRoman, or guessing both encodings first or to default system 
>encoding (0).

I just did this:

1. Entered text into an RB 5.1fc4 editfield as "metá"
2. Save to a Valentina db TEXT field with language set to English
3. Search -> select * from references where thefield = 'metá'

and found that reference.

Jon