MariaDB with latin5_turkish_ci collation

[Antonio Linares]

I am asking Rao to review it, thanks

[Horizon]

Hi,

I can convert my dbf file to MariaDB using importfromdbf with "latin5_turkish_ci". I see the right characters in HeidiSQL. There is not problem.

But all turkish characters are shown "?" in gets and xbrowse.

[Horizon]

Hi,

Is it possible?. Is there any scheduled time?

[Horizon]

Hi Mr. Rao,

Is there any hope?

[nageswaragunupudi]

Please give me a little time.
We both will try and find a solution soon.

[Horizon]

Please give me a little time.
We both will try and find a solution soon.

OK.

[Horizon]

up!

[Horizon]

up!!

[Horizon]

Hi,

My research:

In HeidiSQL my Data.

In HeidiSQL. We try to use latin5, latin5 is ISO 8859-9 Turkish.

in https://harbour.github.io/doc/harbour.htmlIn selected line says Language identifier is TRISO.

My Main app.

Code: Select all  Expand view

? HB_CDPSELECT()

Result is TRISO.

But the result is same. There is still Turkish character problem. It displays "?".


What should I check next.

[Horizon]

Hi Mr. Rao,

If I change this line like that

Code: Select all  Expand view

FW_SetUnicode( .t. )

All Turkish characters is OK. But the data is read from database is unicode.

[nageswaragunupudi]

May I ask, if you browse a DBF with the same Turkish character data, are you able to see the data correctly, with FW_SetUnicode( .f. ) ?

[Horizon]

May I ask, if you browse a DBF with the same Turkish character data, are you able to see the data correctly, with FW_SetUnicode( .f. ) ?

Hi Mr. Rao,

If you asking dbfcdx using, Yes.

[nageswaragunupudi]

Does this DBF browse display correctly? Please confirm.

[Horizon]

Hi Mr. Rao,

I have found the smssablon.dbf that is referred by you.

I have transferred to mariadb via Importfromdbf with "latin5_turkish_ci" charset.





with this code:

Code: Select all  Expand view

    REQUEST HB_CODEPAGE_TRWIN
    HB_CDPSELECT( "TRWIN" )

    //ISO 8859-9 Turkish - It does not matter with TRWIN.
//  REQUEST HB_CODEPAGE_TRISO
//  HB_CDPSELECT( "TRISO" )
   
    cObj_Charset := "latin5_turkish_ci"
    FW_SetUnicode( .t. )

[nageswaragunupudi]

I have imported the above dbf to mysql with this program.
XBrowse of the MySql matches with the xbrowse of the dbf.
I do not find any ?? in the display.

I did not set FW_SetUnicode( .t. ).
So, this is not a Unicode application.

Code: Select all  Expand view

#include "fivewin.ch"

REQUEST DBFCDX
REQUEST HB_CODEPAGE_TRWIN

static oCn

function Main()

   local cDbf     := "turkish\smssblon.dbf"
   local cTable   := cFileNoExt( cDbf )

   HB_CDPSELECT( "TRWIN" )

   RDDSETDEFAULT( "DBFCDX" )

   oCn := FW_DemoDB()
   if oCn == nil
      ? "Connnect Fail"
      return nil
   endif
   ? oCn:cServerInfo
   if oCn:TableExists( cTable )
      oCn:DropTable( cTable )
   endif
   oCn:ImportFromDbf( cDbf )

   XBROWSER cDbf NOMODAL
   XBROWSER oCn:smssblon

   oCn:Close()

return nil

I do not see any problem.