1. Forum
  2. Usenet
  3. COMP.LANG.CLIPPER.VISUAL-

  • SQL Special characters

    From Henry Fidler@21:1/5 to All on Wed Jun 30 11:46:27 2021
    I am using "MySQL ODBC 8.0 Unicode Driver" from oracle.
    The MySQL is collated “utf8_general_ci”
    Calling oSQLSelect:FieldGetFormatted()
    I do not get the european letters, for example instead of “ä”, I get “ä”.

    How can I get the real characters?

    Henry

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From dlzc@21:1/5 to Henry Fidler on Thu Jul 1 09:52:12 2021
    Dear Henry Fidler:

    On Wednesday, June 30, 2021 at 11:46:28 AM UTC-7, Henry Fidler wrote:
    I am using "MySQL ODBC 8.0 Unicode Driver" from oracle.
    The MySQL is collated “utf8_general_ci”
    Calling oSQLSelect:FieldGetFormatted()
    I do not get the european letters, for example instead of “ä”, I get “ä”.

    How can I get the real characters?

    I know this does not help much but the contents of the file are NOT encoded as "utf8_general_ci", or your "display" means is not understanding "utf8_general_ci".

    https://en.wikipedia.org/wiki/UTF-8

    I submit it is stored as a 2-byte character (and you are getting both bytes), and your display means is expecting only single bytes.

    David A. Smith

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Wolfgang Riedmann@21:1/5 to Henry Fidler on Fri Jul 2 07:08:23 2021
    Hi Henry,

    VO does not uses Unicode.

    In the VO System Library there are two functions that are not in the
    help:
    UTF82Ansi() and Ansi2UTF8()

    FUNCTION Ansi2UTF8(cString AS STRING) AS STRING
    RETURN ConvertFromCodePageToCodePage(cString, CP_ACP, CP_UTF8)

    FUNCTION Utf82Ansi(cString AS STRING) AS STRING
    RETURN ConvertFromCodePageToCodePage(cString, CP_UTF8, CP_ACP)

    HTH

    Wolfgang


    Henry Fidler wrote:

    I am using "MySQL ODBC 8.0 Unicode Driver" from oracle.
    The MySQL is collated “utf8_general_ci”
    Calling oSQLSelect:FieldGetFormatted()
    I do not get the european letters, for example instead of “ä”, I
    get “ä”.

    How can I get the real characters?

    Henry



    --

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Henry Fidler@21:1/5 to All on Sat Jul 3 02:04:42 2021
    Wolfgang vielen Dank, it does save time.

    Where can one see the undocumented functions?

    Henry

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Wolfgang Riedmann@21:1/5 to All on Sun Jul 4 15:18:18 2021
    Hi Henry,

    it does save time.

    Where can one see the undocumented functions?

    try to look in the System Library - maybe you find something other
    useful.

    Wolfgang

    --

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)