FiveTech Software tech support forums

... APROG :=DIRECTORY(cFILE) PUBLIC PROGNOM:=APROG[1,1] PUBLIC PROGTAM:=APROG[1,2] PUBLIC PROGFEC:=APROG[1,3] PUBLIC PROGHRS:=APROG[1,4] * cFileG := StrToHex(MemoRead(cFILE)) * cCMDVAL :="" cCmdSql := "INSERT INTO PROGRAMA(TIPO,ARCHIVO,NOMBRE,FECHA,TAMA,HORA) VALUES( " cCMDVAL ...

I used cMimeEnc() instead of strtohex()

... into a "text" string. How? The only function available is HB_Serialize( bBlock ) --> cBinaryString and then convert into text using STRTOHEX(), before we encode it as Json or directly save into a field. Unfortunately, this function is working in xHarbour only and not in Harbour. ...

hi, here are German Sign from 32 to 255 STRTOHEX( cSign ) = "20" ASC( cSign ) = 32 STRTOHEX( cSign ) = "21" ASC( cSign ) = 33 STRTOHEX( cSign ) = "22" ASC( cSign ) = 34 STRTOHEX( cSign ) = "23" ASC( cSign ...

... to Excel using DrXlsx, NOT XBROWSE i like to get a working Excel Sheet with German "Umlaute" using DrXlsx --- when you ask me for STRTOHEX() i got xValue = "„" STRTOHEX(xValue) = "84" ASC(xValue) = 132 xValue = "”" STRTOHEX(xValue) = "94" ...

hi, this i got when have use DBU and fill it with German Umlaute xValue = "ä" STRTOHEX(xValue) = "84" ASC(xValue) = 132 xValue = "ö" STRTOHEX(xValue) = "94" ASC(xValue) = 148 xValue = "ü" STRTOHEX(xValue) = "81" ...

... purely for my knowledge and educational purpose. Can you please post some OEM strings here in Hex? cTextOEM := FieldGet( n )cTextHex := STRTOHEX( cTextOEM )  and please post the hex string. A few strings like that. I am not sure if I can do, but would like to try to convert to ...

... it on the screen or in print. Depends on how this string is encoded. We can find out its encoding by testing with IsUtf8() or still better, with STRTOHEX( c ) The same character is encoded as hex "FC" in ANSI and encoded as hex "C3BC" in UTF8. When FWH displays, both look ...

... ) oRsRTF := CargaRecordSet( "select * from demo1 where id = 2", CadenaCon ) oRsRTF:ADDNEW() oRsRTF:Fields( "testo" ):Value := STRTOHEX(wvar) oRsRTF:Update() oRsRTF:Close() de esta manera lo guarda sin errores. Saludos Jorge

Así lo realizó yo, reemplaza la función memoread por Filestr.

csql = "INSERT INTO demo (testo) VALUES ( "+ STRTOHEX( FileoStr( ".\TestRTF.RTF" ) ) + ")"

Acá ver qué te falta () después de value.

Que error te muestra?

Salu2

Así es como intento guardarlo: csql = "INSERT INTO demo (testo) VALUES "+ STRTOHEX( MEMOREAD( ".\TestRTF.RTF" ) ) y así está creada la base: CREATE TABLE [dbo].[demo]( [id] [int] IDENTITY(1,1) NOT NULL, [testo] [text] NULL ) ON [PRIMARY] TEXTIMAGE_ON ...

... Error: Unresolved external '_HB_FUN_HGETCASEMATCH' referenced from C:\XBASE\HARBOUR32\LIB\FIVEH.LIB|TRECSET Error: Unresolved external '_HB_FUN_STRTOHEX' referenced from C:\XBASE\HARBOUR32\LIB\FIVEH.LIB|TRECSET Error: Unresolved external '_HB_FUN_TOKEN' referenced from C:\XBASE\HARBOUR32\LIB\FIVEH.LIB|TRECSET ...

... "ID=230" )  If you use any other library or want to write your own SQL statements to insert or update a table use "0x" + STRTOHEX( MEMOREAD( cFile ) ), without enclosing in quotes. You can also use FW_ValToSQL( cBinaryText, .t., "MYSQL" ) Note: The conversion ...

... NIL If you are writing the encrypted value to some file and then later trying to decrypt the value then please try StrToHex() and HexToStr() Thank you my friend! In fact I’m saving it in a MariaDB table as a LONGBLOB column. Do I need to use strtohex and hextostr ...

... NIL If you are writing the encrypted value to some file and then later trying to decrypt the value then please try StrToHex() and HexToStr()