[V4RB] SQL Queries/RB5.1/Unicode

[Christer Olsson]

>on 4/25/03 2:43 PM, Stan R. Busk at maxprog at mac.com wrote:
>
> > Hi,
> >
> > New RB5.1 uses Unicode UTF8 everywhere, this is great! But when you
> > take a string from an edit field to be part of an SQL query and this
> > string contains an accentuated character, it always returns 0 entries
> > found (works fine with raw ASCII characters though). I have tried to
> > convert this string in many ways unsuccessfully, basically from UTF8 to
> > MacRoman. I almost tried everything getting wrong results like char "à"
> > converted to "a'" and so on...
> >
> > When I guess a Valentina VVarchar field encoding it returns Base=&hA01
> > with Variant=0 when it contains no accentuated chars but nil when it
> > does!
> >
> > I know UTF8 support is being added to Valentina and I will likely then
> > convert all my database strings to it but on the meantime I would like
> > to know how could I make it work with my current database strings,
> > basically how can I take an UTF8 string and add it to my SQL query
> > securely?
>
>Well, for old RB you send to Valentina strings in MacRoman, correct?
>
>And String/VarChar field must have correct language to be set.
>
>So if you have correct language, and in RB 5.1 you convert to MacRoman
>before you send to Valentina then must work...
>
>May be somebody else have more info.

We're using successfully it on all platforms RB supports. Convert your searchstring to MacRoman (or systemdefault).
-- 

  *************************************************************
  Christer Olsson   PO Box 9160        Phone +46 40 25 85 85
  Ljusa Idéer AB    SE-200 39 Malmoe   Fax +46 40 25 85 89
  Kantyxegatan 5    Sweden             http://www.ljusaideer.se