MySQL UDFs (without ODBC)

[TpeTTeT]

Share UDF, please. Links in the topic do not work. I'll be very grateful 

[mdepot]

@ProgAndy

I tried to download this today, and your server is just returning a 403: Forbidden response.

I'm actually getting a 403 from all links on your domain web server http://progandy.de/

Looking forward to trying out this UDF.   Thanks

 

 

[mdepot]

Actually, a whois lookup suggests the domain might no longer be active.  If someone else has a copy of this UDF, please repost a link to an alternate download location.  Or if it's small enough, perhaps even paste the code here in the forum?   It would be a shame for this to become no longer available, as it looks like it could be really useful to many people.  Thanks!

[RandalBY]

On 7/4/2018 at 5:07 AM, TpeTTeT said:

Share UDF, please. Links in the topic do not work. I'll be very grateful 

https://cloud.mail.ru/public/2T5w/jUJY6cDKZ

[Ujube]

Hey Guys, i have a statement problem.. i don't know, how put on this correctly.. 

$fdata = "INSERT INTO `asd`.`qwe` (`name`,`lname`,`email`,`note`) VALUES (" & _
"'" & $sName & "'," & _
"'" & $sLname & "'," & _
"'" & $sEmail & "'," & _

;~ If StringInStr($ctrl, "'") Then
;~ If StringInStr($val, ",") Then
;~  "'" & StringSplit($val, ',', $STR_ENTIRESPLIT)[1] & "');"
;~ Else
;~  "'" & $val & "');"
;~ EndIf
;~ Else
;~  "'" $empty "');"
;~ EndIf
_MySQL_Real_Query($cnn, $fdata)

i'll be so much grateful..

*****************************************

Solution..

$fdata = "INSERT INTO `asd`.`qwe` (`name`,`lname`,`email`,`note`) VALUES (" & _
;~ db col - name
"'" & $sName & "'," & _
;~ db col - lname
"'" & $sLname & "'," & _
;~ db col - email
"'" & $sEmail & "',"
;~ db col - note
If StringInStr($ctrl, "'") Then
  If StringInStr($val, ",") Then
    $fdata = $fdata & "'" & StringSplit($val, ',', $STR_ENTIRESPLIT)[1] & "');"
  Else
    $fdata = $fdata & "'" & $val & "');"
  EndIf
Else
  $fdata = $fdata & "'" & $empty & "');"
EndIf
_MySQL_Real_Query($cnn, $fdata)

maybe it helps someone..

Edited April 15, 2019 by Ujube

[argumentum]

2 hours ago, Daymond said:

Does anyone still have the zip file for this?

the link at https://www.autoitscript.com/forum/topic/85617-mysql-udfs-without-odbc/?do=findComment&comment=1421885 is functional.

 

[asparagus]

Hi , Anydy

Thanks for your great work.  Today , I tried to use this UDF  and had successful fetch records from my databae. Unfortunately , It can not display the Chinese big5 character. what's wrong with it ? my c connector driver version is 6.1 1 and  mysql was 8.0.17.  Could you help me with it ?  Much Thanks in advance!  Or someone's help  would be appreciated

Asparagus

 

.

[jchd]

I haven't looked and I don't use MySQL but most probably the various functions in this UDF deal with native AutoIt strings which are Unicode UTF16-LE.

In case this is the cause, you can convert wide strings to any codepage (including double-byte types like Big5) and vice-versa with these functions:

Func _StringToCodepage($sStr, $iCodepage = Default)
    If $iCodepage = Default Then $iCodepage = 65001        ; or Int(RegRead("HKLM\SYSTEM\CurrentControlSet\Control\Nls\Codepage", "OEMCP"))
    Local $aResult = DllCall("kernel32.dll", "int", "WideCharToMultiByte", "uint", $iCodepage, "dword", 0, "wstr", $sStr, "int", StringLen($sStr), _
            "ptr", 0, "int", 0, "ptr", 0, "ptr", 0)
    Local $tCP = DllStructCreate("char[" & $aResult[0] & "]")
    $aResult = DllCall("Kernel32.dll", "int", "WideCharToMultiByte", "uint", $iCodepage, "dword", 0, "wstr", $sStr, "int", StringLen($sStr), _
            "struct*", $tCP, "int", $aResult[0], "ptr", 0, "ptr", 0)
    Return DllStructGetData($tCP, 1)
EndFunc   ;==>_StringToCodepage

Func _CodepageToString($sCP, $iCodepage = Default)
    If $iCodepage = Default Then $iCodepage = 65001        ; or Int(RegRead("HKLM\SYSTEM\CurrentControlSet\Control\Nls\Codepage", "OEMCP"))
    Local $tText = DllStructCreate("byte[" & StringLen($sCP) & "]")
    DllStructSetData($tText, 1, $sCP)
    Local $aResult = DllCall("kernel32.dll", "int", "MultiByteToWideChar", "uint", $iCodepage, "dword", 0, "struct*", $tText, "int", StringLen($sCP), _
            "ptr", 0, "int", 0)
    Local $tWstr = DllStructCreate("wchar[" & $aResult[0] & "]")
    $aResult = DllCall("kernel32.dll", "int", "MultiByteToWideChar", "uint", $iCodepage, "dword", 0, "struct*", $tText, "int", StringLen($sCP), _
            "struct*", $tWstr, "int", $aResult[0])
    Return DllStructGetData($tWstr, 1)
EndFunc   ;==>_CodepageToString

Use the codepage IDs defined there https://docs.microsoft.com/fr-fr/windows/win32/intl/code-page-identifiers

For instance, Big5 is 950.

Edited September 30, 2019 by jchd

[noellarkin]

On 3/17/2019 at 7:34 AM, RandalBY said:

https://cloud.mail.ru/public/2T5w/jUJY6cDKZ

This isn't working for me either. Could someone please reupload this UDF?