Skip to content

Instantly share code, notes, and snippets.

View voicenter's full-sized avatar

Voicenter voicenter

View GitHub Profile
@voicenter
voicenter / ChangeCollate.sql
Last active December 4, 2024 19:24
Mysql Change Collate and CHARACTER for all db ,tables and columns
set @COLLATE_Target ='utf8mb4_unicode_ci';
set @CHARACTER_Target ='utf8mb4';
set @sqlstrDB ='ALTER DATABASE {{DB}} CHARACTER SET = {{CHARACTER}} COLLATE = {{COLLATE}};';
set @sqlstrTable ='ALTER TABLE {{DB}}.{{TABLE}} CONVERT TO CHARACTER SET {{CHARACTER}} COLLATE {{COLLATE}};';
set @sqlstrColumn =' ALTER TABLE {{DB}}.{{TABLE}} MODIFY {{COLUMN}} {{COLUMN_TYPE}}({{COLUMN_SIZE}}) CHARACTER SET {{CHARACTER}} COLLATE {{COLLATE}};';
set @sqlstrTextColumn =' ALTER TABLE {{DB}}.{{TABLE}} MODIFY {{COLUMN}} {{COLUMN_TYPE}} CHARACTER SET {{CHARACTER}} COLLATE {{COLLATE}};';
@JamesHagerman
JamesHagerman / stslte-notes.md
Last active March 17, 2024 20:37
My notes about running srsLTE

srsLTE notes

These are notes I've taken while rying to get srslte up and running. This is messy, sorry...

Working solution - LimeSDR + SoapySDR + srsLTE

Dependencies:

sudo apt install tree vim git g++ make cmake pkg-config libpython-dev python-numpy swig libi2c-dev libusb-1.0-0-dev libfftw3-dev libmbedtls-dev libboost-program-options-dev libconfig++-dev libsctp-dev gnuradio