Korean character problem...

[csincuir]

Hello everyone.
I want to request help for this problem.
I have a need to present a field in Korean, which is stored correctly in a MySQL table and if I do the query, it is also presented correctly.
But at the moment of presenting it in my program I only see question marks ???

See the following image:


I already tried putting the FW_SetUnicode (.T.) Instruction at the start of my system, I already tried trying to convert the field with UTF16toUTF8 (oBase: FieldGet (7)), but nothing.
I am using Eagle1 for connection with MySQL and FWH 19.09

Does anyone know how to correctly present these characters in Korean with FWH?

Best regards.

Carlos Sincuir.

[nageswaragunupudi]

We can try to help you if you if you can load a sample table on a server in the cloud that both you and we can access.

We advise you to connect to this server in the cloud and create a small sample tale:

Server: 208.91.198.197
Username: gnraofwh
password: Bharat@1950
Database: fwhdemo
Port: 3306

[csincuir]

Thanks Nages for your help.
I have already created the table in the cloud database.


Thanks in advance.

Best regards.

Carlos Sincuir

[csincuir]

Hi Rao, I have another problem
I have noticed another problem with these Korean characters, when presenting them in a Get, they are not seen either


Could you help me with this other problem please

Best regards.

Carlos Sincuir

[nageswaragunupudi]

Please try this small sample.

Code: Select all  Expand view  RUN

#include "fivewin.ch"

function Main()

   local oCn, oRs

   FW_SetUnicode( .t. )

   FWCONNECT oCn HOST "208.91.198.197:3306" USER "gnraofwh" PASSWORD "Bharat@1950" DATABASE "fwhdemo" PORT "3306"
   if oCn == nil
      ? "Connect fail"
      return nil
   endif

   oRs   := oCn:RowSet( "catcuentasconta" )
   XBROWSER oRs TITLE FWVERSION FASTEDIT AUTOFIT
   oRs:Close()

   oCn:Close()

return nil
 

This sample connects to the MySql server using the inbuilt MySql/Maria library, without using any 3rd party librarires.
Korean characters are read and displayed properly, you can edit and store Korean text and Gets also work properly.

[csincuir]

thanks Rao, I'm going to do the tests

Best regards

[csincuir]

Hi Rao,
I did the tests, and indeed your example works fine on my aplication.

What I don't understand is because if I'm using the same libraries and DLL's, TWBrowse and Get's won't work in a dialog from resources?
Is it not possible to use Korean characters in this way?


On the other hand, if I put FW_SetUnicode (.t.) in the start of my application, this no longer works:

Code: Select all  Expand view  RUN

REDEFINE GET oPass VAR cPass ID 12 OF oDlg PICTURE "@K ;
  CUEBANNER "Ingrese su Contraseña..."  BITMAP "search"
 
   oPass:lBtnTransparent := .t.      
   oPass:lPassword := .t.

The latter does not worry me so much, the former worries me more

Best regards.

Carlos Sincuir

[nageswaragunupudi]

1) You should compulsorily use FW_SetUnicode( .t. ) at the beginning of your program.
There is no use of testing with and without this setting. That is only a waste of time.

2) All UI including Gets should work with resources too.

We can help you better if you post a very small sample prg and rc for testing at our end. (Hint: for Unicode test gets do not use any picture clause. Not even @K. Actually, with FWH gets, @K has not use. )

[csincuir]

Mr. Rao, thank you for the support you are giving me to solve this problem.
Of course I can prepare a small project with so you can see how I am working.
What email address can I send the project to?

Best regards.

Carlos Sincuir