HMG3.6 and MySQL

[serge_girard]

Some strange behaviour I found...

I have a sql-field defined as CHAR(1) in my table.

When selecting it like this:

Code: Select all

 ? 'aCurRow1:fieldGet(9)',  aCurRow1:fieldGet(9), len(aCurRow1:fieldGet(9))
 ? 'trim aCurRow1:fieldGet(9)', alltrim(aCurRow1:fieldGet(9)), len(aCurRow1:fieldGet(9))

It should always give a CHAR(1) and LEN=1 as result but first result is LEN=4

Any idea somebody?

Serge

[edk]

Hi. What you get with hb_ulen(aCurRow1:fieldGet(9)) and hb_utf8len(aCurRow1:fieldGet(9)) ?

[serge_girard]

Hi Edward,

Both suggestions give also LEN=4 !
Field with char(50) gives len=200.
latin1_swedish_ci

Serge

[serge_girard]

It looks like all fields len * 4...

[edk]

Try the test with a different libmysql.dll library

[serge_girard]

Thx, I try tomorrow!

[serge_girard]

Edward,

Is it possible to retrieve version number libmysql.dll when running to program?

Serge

[serge_girard]

Found out how to get file_info..
S