Fernando Mertins fmertins

## fn_remove_accents.sql
DROP FUNCTION IF EXISTS fn_remove_accents;
DELIMITER |
CREATE FUNCTION fn_remove_accents( textvalue VARCHAR(10000) ) RETURNS VARCHAR(10000)

BEGIN

    SET @textvalue = textvalue COLLATE utf8_general_ci;;

    -- ACCENTS
    SET @withaccents = 'ŠšŽžÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÑÒÓÔÕÖØÙÚÛÜÝŸÞàáâãäåæçèéêëìíîïñòóôõöøùúûüýÿþƒ';

## smbsync.py
#!/usr/bin/env python

""" One-way sync to an SMB/CIFS server (needs pysmb) """

import logging, socket, os, sys, math
from datetime import datetime
try:
    from smb.SMBConnection import SMBConnection
    from smb.base import NotReadyError, NotConnectedError
    from nmb.NetBIOS import NetBIOS

## php_mdb.rst

      
        
          
            
              
              1 file
            
          
          
            
              
              11 forks
            
          
          
            
              
              21 comments
            
          
          
            
              
              59 stars
            
          
        
        
          
              
          
          
            
                amirkdv
                / php_mdb.rst
            
            
              Last active
              August 25, 2023 13:14
            
              
                How to handle MS Access MDB files in Linux with PHP5 PDO and ODBC
              
          
        
      
        
  
      
    To be able to use PHP5 PDO with MS Access mdb files the following is required
(the same applies for the PHP4 style of using odbc_X except for the
obviously PDO specific requirements):

PHP ODBC module

In Linux this is achieved by intalling the php5-odbc package:
	DROP FUNCTION IF EXISTS fn_remove_accents;
	DELIMITER \|
	CREATE FUNCTION fn_remove_accents( textvalue VARCHAR(10000) ) RETURNS VARCHAR(10000)

	BEGIN

	SET @textvalue = textvalue COLLATE utf8_general_ci;;

	-- ACCENTS
	SET @withaccents = 'ŠšŽžÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÑÒÓÔÕÖØÙÚÛÜÝŸÞàáâãäåæçèéêëìíîïñòóôõöøùúûüýÿþƒ';
	#!/usr/bin/env python

	""" One-way sync to an SMB/CIFS server (needs pysmb) """

	import logging, socket, os, sys, math
	from datetime import datetime
	try:
	from smb.SMBConnection import SMBConnection
	from smb.base import NotReadyError, NotConnectedError
	from nmb.NetBIOS import NetBIOS