Has been using 12.5, the recent turn in the blob string always garbled, when initially didn't find the reason, today in version 10.5 environment to run the same code, completely normal, version 12.5, and this version has a problem, I asked the great spirit answer
This version of the

CodePudding user response:

The code! There is not even an example

CodePudding user response:

String st_empid
String is_user is_pwd, ls_pwd
Blob lblb_pwd

St_empid=trim (sle_1. Text)
SELECTBLOB security_users. Passwd
Into: lblb_pwd
The FROM security_users
The WHERE (security_users. Name=: st_empid) AND
(security_users user_type=0) AND
(security_users userstatus='1')
Using trans_bh;
Sle_2. Text=string (lblb_pwd)
Sle_3. Text=f_getstr (string (lblb_pwd))
So a simple code, just below 11.5 also tested like 12.5, 10.5 no problem

CodePudding user response:

This is the result of 12.5 ran out, breakpoint debugging after take out the data on the blob string is all the code

This is ran 10.5

O great god answer

CodePudding user response:

refer to the second floor qq_18475813 response:

string st_empid
String is_user is_pwd, ls_pwd
Blob lblb_pwd

St_empid=trim (sle_1. Text)
SELECTBLOB security_users. Passwd
Into: lblb_pwd
The FROM security_users
The WHERE (security_users. Name=: st_empid) AND
(security_users user_type=0) AND
(security_users userstatus='1')
Using trans_bh;
Sle_2. Text=string (lblb_pwd)
Sle_3. Text=f_getstr (string (lblb_pwd))
So a simple code, just below 11.5 also tested like 12.5, 10.5 no problem

Sle_2. Text=string (lblb_pwd EncodingANSI!) So try
Or it
Sle_2. Text=string (lblb_pwd EncodingUTF8!)

CodePudding user response:

Thank moderator to solve, try tomorrow, now home machine no environment

CodePudding user response:

@ WorldMobile moderator greatly, it is 10.5 and 12.5 version is not the same as the default encoding problem,

CodePudding user response:

@ WorldMobile lzp_lrp thank moderator greatly , test the ANSI encoding and utf8 can today, both encoding results are the same, thank you thank you