TGET strange behavior for Unicode.

[dutch]

Dear Mr.Rao,

I got the TGET limitation. I define column as VARCHAR 250.

But I can enter character 100 characters only as picture.

post pics

I try to change Character Set from "UTF8" to "latin1". It is still allow to enter 100 characters only.

When I use len() function to check the column size, it show 100.

I try to use as below;

Code: Select all  Expand view  RUN

@ 85, 55 GET oGet[07] VAR MEMVAR->REP:REP_FIL    OF oDlg SIZE 240,13 PIXEL ANSI LIMITBYCHARS .F. CHRGROUP CHR_ANSI

It is still doesn't work.

I try to add character in other tool (Navicat) more 100 character, become 150. When I use Len() it show 150.

Thank you in advance.

Best regards,
Dutch

[nageswaragunupudi]

1) Please reset the character set to "utf8" collation "utf8_unicode_ci"

2) Define the Get like this:

Code: Select all  Expand view  RUN

@ 85, 55 GET oGet[07] VAR MEMVAR->REP:REP_FIL    OF oDlg SIZE 240,13 PIXEL CHRGROUP CHR_WIDE
oGet[07]:nMaxChars := 255
 

[dutch]

Dear Mr.Rao,

Thank you so much. It's working now.
Why does the program desire ::nMaxChars from column length? Because we have to modify program, if we change the columns size.

Thanks in advance.

[nageswaragunupudi]

Code: Select all  Expand view  RUN

oGet[07]:nMaxChars := MEMVAR->REP:FIELDLEN( "REP_FIL" )
 

Alternatively, you can set globally

Code: Select all  Expand view  RUN

MYSQL_MaxPadLimit( 255 )

[dutch]

Dear Mr.Rao,

This one is working well.
[quote="nageswaragunupudi"]

Code: Select all  Expand view  RUN

oGet[07]:nMaxChars := MEMVAR->REP:FIELDLEN( "REP_FIL" )
 

Thank you so much.