[V4RB] SQL Queries/RB5.1/Unicode

[Stan R. Busk]

Hi,

Yes, this works here too but it doesn't work with records created with 
my older RB4.5.3 version.

Stan

> 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

>> 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).

-- 
MAX Programming, LLC
<http://maxprog.com>