1. PRASHANT NIRGUN
  2. PowerBuilder
  3. Saturday, 30 March 2019

Hi

This is Prashant here I am facing probem with unicode numeric datatype. Which I believe could be for numeric values unicode \u and I set Edit mask Format = ###,###. If I removed Edit Mask and allow it return garbage value.

If fails to enter numeric and date datatype to access from datawindow. 

Using following versions

Windows : 7 64 Bit

PB 12.5.2 Build 5583 Classical

MySQL 5.5.38, 

MySQL ODBC 5.3 UNICODE Driver.

Keyboard ; India (US)

Connection String 

dbms = ODBC
dbparm = Connectstring='DRIVER=MySQL ODBC 5.3 UNICODE Driver;UID=root;
PWD=xxx; Database=Veg10;Server=localhost;OPTION=4096',DelimitIdentifier='No',OJSyntax='ANSI';
ConnectOption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'


Is it a compilation or dll which is not unicode. Totally frustated wiith the numeric and datatype values handling. Kindly help feeling sucked.

Thanks in advance.

Chris Pollach Accepted Answer Pending Moderation
1
Votes
Undo

Hi Prashant;

   Unicode encoding typically refers to nChar, nVarChar, and nText based data types. All numeric data types are encoded neutrally (Int, Double, Real, Decimal, etc). However the DBMS needs to follow "ANSI Result Set" standards when returning a data stream so that the DB Client driver (in your ODBC) can parse the values out properly.

   I wonder if your issue is either in the MySQL ODBC driver or the way the data is handed over to the PB ODBC "Interface" DB driver. An ODBC DB buffer trace might be the the thing to do now to see exactly what is being returned to either the PB IDE or your App, as follows:

SQLCA.DBMS = "TRACE ODBC"

HTH

Regards ... Chris

Comment
There are no comments made yet.
  1. Monday, 1 April 2019
  2. PowerBuilder
  3. # 1
PRASHANT NIRGUN Accepted Answer Pending Moderation
0
Votes
Undo

I forgot to mention I am using Marathi (US) keyboard I set up 

Constant long LANG_MARATHI = 72221774

ActivateKeyboardLayout(LANG_MARATHI , KLF_REORDER)

please refer https://community.appeon.com/index.php/qna/q-a/pb-12-5-windows-controls-support-unicode-sle-ddlb-picture-button

Now the problem is error I am getting is at item change level I not yet commited the data. I just inserted row using dw_1.insertRow(0)
And I am trying to enter value in int or decimal(12,2) columns it pushes the wrong value. I can understand charset is for string columns.
I think U+XXXX is value dw is accepting and try to convert it to numeric equivalent value its converting \U to numeric value.

I try to set ActiveKeyboard Layout in Itemfocuschanged event to
ActivateKeyboardLayout(LANG_US_ENGLISH , KLF_REORDER) in choose case for numeric columns but it setitem wrong values.

Thanks for your reply
 
Comment
There are no comments made yet.
  1. Tuesday, 2 April 2019
  2. PowerBuilder
  3. # 2
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.