Fivewin & TDolphin & MariaDb & UFT8 problem?

[bigcco]

Hello, everyone!
My name is Kim Jung Ho and I live in Korea.
I am going to use MariaDb using Tdolphin library.
If you connect normally and read the data, the letters are broken and visible. How can I solve this problem? Help me. Please.

https://blogfiles.pstatic.net/MjAyMjExMDRfMjg1/MDAxNjY3NTM5NjUxMzc3.HIlhcRGsvnDZmSpRgvIEWQUIe8FGttu_6aJAKQWoQbkg.M_6RQebb6ROpzwMlrJV22q9bwBjuyZy-twaH7dxFCuwg.JPEG.bigcco2006/error.jpg

Code: Select all  Expand view

#include "Fivewin.ch"
#include "TDolphin.ch"

procedure Main()
    local oServer
    local cHost     := "127.0.0.1"
    local cUser     := "root"
    local cPassword := "$01khm02khy$"
    local nPort     := 3306
    local nFlags    := 0
    local cDbName   := "bkinfo"

    local oErr

    local oQry
    local aData  := {}
    local cQuery := ""
    local i := 0

    SET CENTURY ON
    SET DATE FORMAT "yyyy.mm.dd"

    HB_SETCODEPAGE( "UTF8" )
    *FW_SetUnicode( .T. )   // It's a function that doesn't exist in my version.

    try
        CONNECT oServer HOST cHost USER cUser PASSWORD cPassword PORT nPort FLAGS nFlags DATABASE cDbName
    catch oErr
        Msginfo( oErr:Description, "Error" )
        RETURN
    end

    oQry  := TDolphinQry():New( "SELECT * FROM test", oServer )
    aData := oQry:FillArray()

    cQuery += "Record Count : "+ Transform(oQry:nRecCount,"999,999") + " / "

    cQuery += "Fields Count : "+ Transform(oQry:nFCount,"999,999") + CRLF + CRLF

    if oQry:nRecCount > 0
        for i := 1 to oQry:nRecCount
            cQuery += "RecNo. "+ALLTRIM(STR(i))+" 무엇이 문제일까?  What is the problem?" + CRLF +;
                           "Name : " + ALLTRIM(aData[i][1])+", Company : "+ALLTRIM(aData[i][2]) + CRLF + CRLF
    next
    endif

    Msginfo( cQuery )

    oQry:End()
    oQry := NIL

    oServer:End()

RETURN

FWH 10.04
xHarbour Compiler build 1.2.1 (SimpLex) (Rev. 6717)
Borland C++ 5.82
TDolphin
MariaDb 10.8

[richard-service]

Hi Mr.Kim

I use TMySQL not problem. but I remember old FWH version UTF8 Unicode not work.
What's FWH version use?

[bigcco]

Hello, Mr. Richard
Can I use MariaDb for TMySQL?
The version I am using is FHW 10.4

[Antonio Linares]

Dear Kim,

You are using a very old FWH version.

You may consider to buy an upgrade to the new FWH 22.10

[nageswaragunupudi]

Advantages of Upgrading:

Unicode:
Highly advanced support for Unicode.

MySql/MariaDB:
Highly advanced MySql/MariaDB built-in library. No need for any external library. Fully compatible with Harbour/xHarour, Borland, GCC and MSVC, 32 and 64 bits.
Far advanced than TMySql, Dolphin and even ADO.
For most normal uses, any MySql library like TMySQL and Dolphin serve the purpose, whether you use MySQL server or MariaDB server.
But there are minor differences between MySQL upto version 5 and version 8 and MariaDB.
FWH' own library knows if the server is MySql, its version and if it is MariaDB. Internally FWH library takes into account takes into account these differences and behaves appropriately.

If you are a serious user of MySQL or MariaDB with Unicode, upgrading will greatly help you.

[CARLOS ATUNCAR]

Estoy usando TDolphin libreria externa para usar la de FWH tendria que hacer algun cambio en mis fuentes ?
uso fwh 20.12

[nageswaragunupudi]

FWH 20.12 works.

Minor changes only.