🔬 Diagnoza kodowania bazy

1. Ustawienia charset MySQL

ZmiennaWartość
character_set_serverutf8mb3
character_set_databaseutf8mb3
character_set_connectionutf8mb4
character_set_clientutf8mb4
character_set_resultsutf8mb4
collation_serverutf8mb3_general_ci
collation_databaseutf8mb3_general_ci

2. Charset kolumn (tabele tekstowe)

TabelaKolumnaCharsetCollation
aktualizacjamail_czas utf8mb3 utf8mb3_general_ci
aktualizacjamail_data utf8mb3 utf8mb3_general_ci
aktualizacjasaldo_czas utf8mb3 utf8mb3_general_ci
aktualizacjasaldo_data utf8mb3 utf8mb3_general_ci
faktury_infaktdane utf8mb3 utf8mb3_general_ci
faktury_infaktinfakt_invoice_id utf8mb3 utf8mb3_general_ci
faktury_infaktinfakt_invoice_uuid utf8mb3 utf8mb3_general_ci
faktury_infaktpayment_status utf8mb3 utf8mb3_general_ci
faktury_infaktshare_link utf8mb3 utf8mb3_general_ci
faktury_infaktstatus utf8mb3 utf8mb3_general_ci
faktury_zgloszeniainvoice_number utf8mb4 utf8mb4_0900_ai_ci
faktury_zgloszeniainvoice_uuid utf8mb4 utf8mb4_0900_ai_ci
faktury_zgloszeniakolor utf8mb4 utf8mb4_0900_ai_ci
faktury_zgloszeniastatus utf8mb4 utf8mb4_0900_ai_ci
finanseabonament_biznes utf8mb3 utf8mb3_polish_ci
finanseabonament_iptv utf8mb3 utf8mb3_general_ci
finanseabonament_iptv_hurt utf8mb3 utf8mb3_general_ci
finanseutrzymanie_iptv utf8mb3 utf8mb3_general_ci
finanseutrzymanie_lacza utf8mb3 utf8mb3_general_ci
finansewydatki_firma utf8mb3 utf8mb3_general_ci
finansewydatki_inne utf8mb3 utf8mb3_general_ci
infakt_payment_cacheinvoice_uuid utf8mb3 utf8mb3_general_ci
infakt_payment_cachepayment_link utf8mb3 utf8mb3_general_ci
iptviptv_nazwa_kanalu latin1 latin1_swedish_ci
iptviptv_numer_kanalu utf8mb3 utf8mb3_unicode_ci
iptviptv_przerwa utf8mb3 utf8mb3_unicode_ci
magazynitem_cena utf8mb3 utf8mb3_general_ci
magazynitem_ilosc utf8mb3 utf8mb3_general_ci
magazynitem_informacje_dodatkowe utf8mb3 utf8mb3_general_ci
magazynitem_nazwa utf8mb3 utf8mb3_general_ci
magazynitem_numer utf8mb3 utf8mb3_general_ci
magazynitem_stan utf8mb3 utf8mb3_unicode_ci
mvno_billingczas_polaczen utf8mb4 utf8mb4_unicode_ci
mvno_billingimport_plik utf8mb4 utf8mb4_unicode_ci
mvno_billingmiesiac utf8mb4 utf8mb4_unicode_ci
mvno_billingmvno_numer utf8mb4 utf8mb4_unicode_ci
mvno_billingp5g_info utf8mb4 utf8mb4_unicode_ci
mvno_billingpromocja_nazwa utf8mb4 utf8mb4_unicode_ci
mvno_billingtaryfa utf8mb4 utf8mb4_unicode_ci
mvno_billing_kategorieczas_laczny utf8mb4 utf8mb4_unicode_ci
mvno_billing_kategorieid_klienta_operatora utf8mb4 utf8mb4_unicode_ci
mvno_billing_kategoriekategoria utf8mb4 utf8mb4_unicode_ci
mvno_billing_kategoriekategoria_typ utf8mb4 utf8mb4_unicode_ci
mvno_billing_kategoriekod_uzytkownika utf8mb4 utf8mb4_unicode_ci
mvno_billing_kategoriemvno_numer utf8mb4 utf8mb4_unicode_ci
mvno_billing_pakietypakiet_nazwa utf8mb4 utf8mb4_unicode_ci
mvno_kategorie_slownikikona utf8mb4 utf8mb4_0900_ai_ci
mvno_kategorie_slownikkategoria_typ utf8mb4 utf8mb4_0900_ai_ci
mvno_kategorie_slownikkierunek utf8mb4 utf8mb4_0900_ai_ci
mvno_kategorie_slowniknazwa_pl utf8mb4 utf8mb4_0900_ai_ci
swiatlowodadres utf8mb3 utf8mb3_general_ci
swiatlowodemail utf8mb3 utf8mb3_general_ci
swiatlowodimie utf8mb3 utf8mb3_general_ci
swiatlowodkod utf8mb3 utf8mb3_general_ci
swiatlowodmiejscowosc utf8mb3 utf8mb3_general_ci
swiatlowodnazwisko utf8mb3 utf8mb3_general_ci
swiatlowodprzylaczenie utf8mb3 utf8mb3_general_ci
tauronbsaadres_alt_kod_simc utf8mb3 utf8mb3_general_ci
tauronbsaadres_alt_kod_ulic utf8mb3 utf8mb3_general_ci
tauronbsaadres_alt_miejsc utf8mb3 utf8mb3_general_ci
tauronbsaadres_alt_nr_porz utf8mb3 utf8mb3_general_ci
tauronbsaadres_alt_ulica utf8mb3 utf8mb3_general_ci
tauronbsacppc utf8mb3 utf8mb3_general_ci
tauronbsadata_got utf8mb3 utf8mb3_general_ci
tauronbsadata_publikacji utf8mb3 utf8mb3_general_ci
tauronbsadlugosc utf8mb3 utf8mb3_general_ci
tauronbsagmina utf8mb3 utf8mb3_general_ci
tauronbsaid_budynku utf8mb3 utf8mb3_general_ci
tauronbsakod_ulic utf8mb3 utf8mb3_general_ci
tauronbsalacze utf8mb3 utf8mb3_general_ci
tauronbsaliczba_laczy utf8mb3 utf8mb3_general_ci
tauronbsaliczba_lokali utf8mb3 utf8mb3_general_ci
tauronbsamiejscowosc utf8mb3 utf8mb3_general_ci
tauronbsanr_porz utf8mb3 utf8mb3_general_ci
tauronbsaobszar utf8mb3 utf8mb3_general_ci
tauronbsaolt utf8mb3 utf8mb3_general_ci
tauronbsapowiat utf8mb3 utf8mb3_general_ci
tauronbsasimc utf8mb3 utf8mb3_general_ci
tauronbsaszerokosc utf8mb3 utf8mb3_general_ci
tauronbsaterc utf8mb3 utf8mb3_general_ci
tauronbsatyp_przylacza utf8mb3 utf8mb3_general_ci
tauronbsaulica utf8mb3 utf8mb3_general_ci
tauronbsauwagi utf8mb3 utf8mb3_general_ci
tauronbsawojewodztwo utf8mb3 utf8mb3_general_ci
tauronbsaaadres_alt_kod_simc utf8mb3 utf8mb3_general_ci
tauronbsaaadres_alt_kod_ulic utf8mb3 utf8mb3_general_ci
tauronbsaaadres_alt_miejsc utf8mb3 utf8mb3_general_ci
tauronbsaaadres_alt_nr_porz utf8mb3 utf8mb3_general_ci
tauronbsaaadres_alt_ulica utf8mb3 utf8mb3_general_ci
tauronbsaacppc utf8mb3 utf8mb3_general_ci
tauronbsaadata_got utf8mb3 utf8mb3_general_ci
tauronbsaadata_publikacji utf8mb3 utf8mb3_general_ci
tauronbsaadlugosc utf8mb3 utf8mb3_general_ci
tauronbsaagmina utf8mb3 utf8mb3_general_ci
tauronbsaaid_budynku utf8mb3 utf8mb3_general_ci
tauronbsaakod_ulic utf8mb3 utf8mb3_general_ci
tauronbsaalacze utf8mb3 utf8mb3_general_ci
tauronbsaaliczba_laczy utf8mb3 utf8mb3_general_ci
tauronbsaaliczba_lokali utf8mb3 utf8mb3_general_ci
tauronbsaamiejscowosc utf8mb3 utf8mb3_general_ci
tauronbsaanr_porz utf8mb3 utf8mb3_general_ci
tauronbsaaobszar utf8mb3 utf8mb3_general_ci
tauronbsaaolt utf8mb3 utf8mb3_general_ci
tauronbsaapowiat utf8mb3 utf8mb3_general_ci
tauronbsaasimc utf8mb3 utf8mb3_general_ci
tauronbsaaszerokosc utf8mb3 utf8mb3_general_ci
tauronbsaaterc utf8mb3 utf8mb3_general_ci
tauronbsaatyp_przylacza utf8mb3 utf8mb3_general_ci
tauronbsaaulica utf8mb3 utf8mb3_general_ci
tauronbsaauwagi utf8mb3 utf8mb3_general_ci
tauronbsaawojewodztwo utf8mb3 utf8mb3_general_ci
umowa_abonenckaadres_instalacji utf8mb4 utf8mb4_0900_ai_ci
umowa_abonenckainformacje_dodatkowe utf8mb4 utf8mb4_0900_ai_ci
umowa_abonenckanr_konta utf8mb4 utf8mb4_0900_ai_ci
umowa_abonenckaokres_umowy utf8mb4 utf8mb4_0900_ai_ci
umowa_abonenckaprotokol_html utf8mb4 utf8mb4_0900_ai_ci
umowa_abonenckazgody_json utf8mb4 utf8mb4_0900_ai_ci
umowa_abonencka_podpisanacennik_snapshot utf8mb4 utf8mb4_0900_ai_ci
umowa_abonencka_podpisanadane_umowy utf8mb4 utf8mb4_0900_ai_ci
umowa_abonencka_podpisanakod_sms utf8mb4 utf8mb4_0900_ai_ci
umowa_abonencka_podpisanaregulamin_snapshot utf8mb4 utf8mb4_0900_ai_ci
umowa_abonencka_podpisanastatus utf8mb4 utf8mb4_0900_ai_ci
umowa_abonencka_podpisanatelefon_sms utf8mb4 utf8mb4_0900_ai_ci
umowa_abonencka_podpisanatoken utf8mb4 utf8mb4_0900_ai_ci
user_mvnomvno_faktura_opis utf8mb4 utf8mb4_unicode_ci
user_mvnomvno_iccid utf8mb4 utf8mb4_unicode_ci
user_mvnomvno_id_klienta utf8mb4 utf8mb4_unicode_ci
user_mvnomvno_informacje utf8mb4 utf8mb4_unicode_ci
user_mvnomvno_kod_uzytkownika utf8mb4 utf8mb4_unicode_ci
user_mvnomvno_koniec_umowy utf8mb4 utf8mb4_unicode_ci
user_mvnomvno_numer utf8mb4 utf8mb4_unicode_ci
user_mvnomvno_pakiet utf8mb4 utf8mb4_unicode_ci
user_mvnomvno_status utf8mb4 utf8mb4_unicode_ci
user_mvnomvno_taryfa utf8mb4 utf8mb4_unicode_ci
usersinwestor_saldo utf8mb3 utf8mb3_general_ci
usersinwestor_wklad utf8mb3 utf8mb3_general_ci
usersinwestor_wyplacono utf8mb3 utf8mb3_general_ci
usersuser_abonament utf8mb3 utf8mb3_general_ci
usersuser_abonament_iptv utf8mb3 utf8mb3_general_ci
usersuser_dowod utf8mb3 utf8mb3_general_ci
usersuser_email utf8mb3 utf8mb3_general_ci
usersuser_faktura_opis utf8mb3 utf8mb3_polish_ci
usersuser_faktura_opis_iptv utf8mb3 utf8mb3_polish_ci
usersuser_faktura_opis_telefon utf8mb3 utf8mb3_general_ci
usersuser_grupa utf8mb3 utf8mb3_general_ci
usersuser_haslo utf8mb3 utf8mb3_general_ci
usersuser_informacje_dodatkowe utf8mb3 utf8mb3_general_ci
usersuser_internet utf8mb3 utf8mb3_general_ci
usersuser_iptv utf8mb3 utf8mb3_general_ci
usersuser_iptv_opcja utf8mb3 utf8mb3_unicode_ci
usersuser_iptv_pakiet utf8mb3 utf8mb3_general_ci
usersuser_kod_pocztowy utf8mb3 utf8mb3_general_ci
usersuser_koniec_umowy utf8mb3 utf8mb3_general_ci
usersuser_koniec_umowy_iptv utf8mb3 utf8mb3_general_ci
usersuser_koniec_umowy_telefon utf8mb3 utf8mb3_general_ci
usersuser_kraj utf8mb3 utf8mb3_general_ci
usersuser_login utf8mb3 utf8mb3_general_ci
usersuser_miejscowosc utf8mb3 utf8mb3_general_ci
usersuser_nazwa utf8mb3 utf8mb3_general_ci
usersuser_nip utf8mb3 utf8mb3_general_ci
usersuser_pakiet utf8mb3 utf8mb3_general_ci
usersuser_pesel utf8mb3 utf8mb3_general_ci
usersuser_pppoe_haslo utf8mb3 utf8mb3_general_ci
usersuser_pppoe_login utf8mb3 utf8mb3_general_ci
usersuser_saldo utf8mb3 utf8mb3_general_ci
usersuser_saldo_iptv utf8mb3 utf8mb3_general_ci
usersuser_technologia utf8mb3 utf8mb3_general_ci
usersuser_telefon utf8mb3 utf8mb3_general_ci
usersuser_telefonia utf8mb3 utf8mb3_general_ci
usersuser_ulica utf8mb3 utf8mb3_general_ci
v_mvno_abonent_summarymiesiac utf8mb4 utf8mb4_unicode_ci
v_mvno_abonent_summaryuser_nazwa utf8mb3 utf8mb3_general_ci
v_mvno_billingczas_polaczen utf8mb4 utf8mb4_unicode_ci
v_mvno_billingimport_plik utf8mb4 utf8mb4_unicode_ci
v_mvno_billingmiesiac utf8mb4 utf8mb4_unicode_ci
v_mvno_billingmvno_id_klienta utf8mb4 utf8mb4_unicode_ci
v_mvno_billingmvno_kod_uzytkownika utf8mb4 utf8mb4_unicode_ci
v_mvno_billingmvno_numer utf8mb4 utf8mb4_unicode_ci
v_mvno_billingpakiety_internet_lista utf8mb4 utf8mb4_unicode_ci
v_mvno_billingpromocja_nazwa utf8mb4 utf8mb4_unicode_ci
v_mvno_billingtaryfa utf8mb4 utf8mb4_unicode_ci
v_mvno_billinguser_nazwa utf8mb3 utf8mb3_general_ci
v_mvno_kat_typykategoria_nazwa utf8mb4 utf8mb4_unicode_ci
v_mvno_kat_typykategoria_typ utf8mb4 utf8mb4_unicode_ci
v_mvno_kat_typymvno_numer utf8mb4 utf8mb4_unicode_ci

3. Przykładowe dane (hex bajtów)

Tabela: faktury_infakt

KolumnaTekst (jak widzi PHP)HEX bajtówDługość
dane{"invoice":{"payment_method":"transfer","kind":"vat","status":"draft","payment_date":"2025-01-15","bank_account":"PL47114020040000370276845419","bank_name":"mBank S.A.","client_company_name":"Jacek Sobko","client_street":"Wojska Polskiego 1B/4","client_post_code":"57-220","client_city":"Ziębice","services":[{"name":"Dostęp do Internetu [usługa telekomunikacyjna] [01.2025]","gross_price":2000,"tax_symbol":23}]}}7b 22 69 6e 76 6f 69 63 65 22 3a 7b 22 70 61 79 6d 65 6e 74 5f 6d 65 74 68 6f 64 22 3a 22 74 72 61 6e 73 66 65 72 22 2c 22 6b 69 6e 64 22 3a 22 76 61 74 22 2c 22 73 74 61 74 75 73 22 3a 22 64 72 61 66 74 22 2c 22 70 61 79 6d 65 6e 74 5f 64 61 74 65 22 3a 22 32 30 32 35 2d 30 31 2d 31 35 22 2c 22 62 61 6e 6b 5f 61 63 63 6f 75 6e 74 22 3a 22 50 4c 34 37 31 31 34 30 32 30 30 34 30 30 30 30 33 37 30 32 37 36 38 34 35 34 31 39 22 2c 22 62 61 6e 6b 5f 6e 61 6d 65 22 3a 22 6d 42 61 6e 6b 20 53 2e 41 2e 22 2c 22 63 6c 69 65 6e 74 5f 63 6f 6d 70 61 6e 79 5f 6e 61 6d 65 22 3a 22 4a 61 63 65 6b 20 53 6f 62 6b 6f 22 2c 22 63 6c 69 65 6e 74 5f 73 74 72 65 65 74 22 3a 22 57 6f 6a 73 6b 61 20 50 6f 6c 73 6b 69 65 67 6f 20 31 42 2f 34 22 2c 22 63 6c 69 65 6e 74 5f 70 6f 73 74 5f 63 6f 64 65 22 3a 22 35 37 2d 32 32 30 22 2c 22 63 6c 69 65 6e 74 5f 63 69 74 79 22 3a 22 5a 69 c3 84 c2 99 62 69 63 65 22 2c 22 73 65 72 76 69 63 65 73 22 3a 5b 7b 22 6e 61 6d 65 22 3a 22 44 6f 73 74 c3 84 c2 99 70 20 64 6f 20 49 6e 74 65 72 6e 65 74 75 20 5b 75 73 c4 b9 c2 82 75 67 61 20 74 65 6c 65 6b 6f 6d 75 6e 69 6b 61 63 79 6a 6e 61 5d 20 5b 30 31 2e 32 30 32 35 5d 22 2c 22 67 72 6f 73 73 5f 70 72 69 63 65 22 3a 32 30 30 30 2c 22 74 61 78 5f 73 79 6d 62 6f 6c 22 3a 32 33 7d 5d 7d 7d417 zn / 423 B
dane{"invoice":{"payment_method":"transfer","kind":"vat","status":"draft","payment_date":"2025-01-15","bank_account":"PL47114020040000370276845419","bank_name":"mBank S.A.","client_company_name":"Małgorzata Koprowska","client_street":"Widokowa 6","client_post_code":"57-220","client_city":"Ziębice","services":[{"name":"Dostęp do Internetu [usługa telekomunikacyjna] [01.2025]","gross_price":3000,"tax_symbol":23}]}}7b 22 69 6e 76 6f 69 63 65 22 3a 7b 22 70 61 79 6d 65 6e 74 5f 6d 65 74 68 6f 64 22 3a 22 74 72 61 6e 73 66 65 72 22 2c 22 6b 69 6e 64 22 3a 22 76 61 74 22 2c 22 73 74 61 74 75 73 22 3a 22 64 72 61 66 74 22 2c 22 70 61 79 6d 65 6e 74 5f 64 61 74 65 22 3a 22 32 30 32 35 2d 30 31 2d 31 35 22 2c 22 62 61 6e 6b 5f 61 63 63 6f 75 6e 74 22 3a 22 50 4c 34 37 31 31 34 30 32 30 30 34 30 30 30 30 33 37 30 32 37 36 38 34 35 34 31 39 22 2c 22 62 61 6e 6b 5f 6e 61 6d 65 22 3a 22 6d 42 61 6e 6b 20 53 2e 41 2e 22 2c 22 63 6c 69 65 6e 74 5f 63 6f 6d 70 61 6e 79 5f 6e 61 6d 65 22 3a 22 4d 61 c4 b9 c2 82 67 6f 72 7a 61 74 61 20 4b 6f 70 72 6f 77 73 6b 61 22 2c 22 63 6c 69 65 6e 74 5f 73 74 72 65 65 74 22 3a 22 57 69 64 6f 6b 6f 77 61 20 36 22 2c 22 63 6c 69 65 6e 74 5f 70 6f 73 74 5f 63 6f 64 65 22 3a 22 35 37 2d 32 32 30 22 2c 22 63 6c 69 65 6e 74 5f 63 69 74 79 22 3a 22 5a 69 c3 84 c2 99 62 69 63 65 22 2c 22 73 65 72 76 69 63 65 73 22 3a 5b 7b 22 6e 61 6d 65 22 3a 22 44 6f 73 74 c3 84 c2 99 70 20 64 6f 20 49 6e 74 65 72 6e 65 74 75 20 5b 75 73 c4 b9 c2 82 75 67 61 20 74 65 6c 65 6b 6f 6d 75 6e 69 6b 61 63 79 6a 6e 61 5d 20 5b 30 31 2e 32 30 32 35 5d 22 2c 22 67 72 6f 73 73 5f 70 72 69 63 65 22 3a 33 30 30 30 2c 22 74 61 78 5f 73 79 6d 62 6f 6c 22 3a 32 33 7d 5d 7d 7d416 zn / 424 B
dane{"invoice":{"payment_method":"transfer","kind":"vat","status":"draft","payment_date":"2025-01-15","bank_account":"PL47114020040000370276845419","bank_name":"mBank S.A.","client_company_name":"Marcin Grzebielec","client_street":"Widokowa 1","client_post_code":"57-220","client_city":"Ziębice","services":[{"name":"Dostęp do Internetu [usługa telekomunikacyjna] [01.2025]","gross_price":4000,"tax_symbol":23}]}}7b 22 69 6e 76 6f 69 63 65 22 3a 7b 22 70 61 79 6d 65 6e 74 5f 6d 65 74 68 6f 64 22 3a 22 74 72 61 6e 73 66 65 72 22 2c 22 6b 69 6e 64 22 3a 22 76 61 74 22 2c 22 73 74 61 74 75 73 22 3a 22 64 72 61 66 74 22 2c 22 70 61 79 6d 65 6e 74 5f 64 61 74 65 22 3a 22 32 30 32 35 2d 30 31 2d 31 35 22 2c 22 62 61 6e 6b 5f 61 63 63 6f 75 6e 74 22 3a 22 50 4c 34 37 31 31 34 30 32 30 30 34 30 30 30 30 33 37 30 32 37 36 38 34 35 34 31 39 22 2c 22 62 61 6e 6b 5f 6e 61 6d 65 22 3a 22 6d 42 61 6e 6b 20 53 2e 41 2e 22 2c 22 63 6c 69 65 6e 74 5f 63 6f 6d 70 61 6e 79 5f 6e 61 6d 65 22 3a 22 4d 61 72 63 69 6e 20 47 72 7a 65 62 69 65 6c 65 63 22 2c 22 63 6c 69 65 6e 74 5f 73 74 72 65 65 74 22 3a 22 57 69 64 6f 6b 6f 77 61 20 31 22 2c 22 63 6c 69 65 6e 74 5f 70 6f 73 74 5f 63 6f 64 65 22 3a 22 35 37 2d 32 32 30 22 2c 22 63 6c 69 65 6e 74 5f 63 69 74 79 22 3a 22 5a 69 c3 84 c2 99 62 69 63 65 22 2c 22 73 65 72 76 69 63 65 73 22 3a 5b 7b 22 6e 61 6d 65 22 3a 22 44 6f 73 74 c3 84 c2 99 70 20 64 6f 20 49 6e 74 65 72 6e 65 74 75 20 5b 75 73 c4 b9 c2 82 75 67 61 20 74 65 6c 65 6b 6f 6d 75 6e 69 6b 61 63 79 6a 6e 61 5d 20 5b 30 31 2e 32 30 32 35 5d 22 2c 22 67 72 6f 73 73 5f 70 72 69 63 65 22 3a 34 30 30 30 2c 22 74 61 78 5f 73 79 6d 62 6f 6c 22 3a 32 33 7d 5d 7d 7d412 zn / 418 B

Tabela: mvno_billing

KolumnaTekst (jak widzi PHP)HEX bajtówDługość
p5g_infoopłata 5G6f 70 c4 b9 c2 82 61 74 61 20 35 4710 zn / 12 B
p5g_infoopłata 5G6f 70 c4 b9 c2 82 61 74 61 20 35 4710 zn / 12 B
p5g_infoopłata 5G6f 70 c4 b9 c2 82 61 74 61 20 35 4710 zn / 12 B

Tabela: mvno_billing_kategorie

KolumnaTekst (jak widzi PHP)HEX bajtówDługość
kategoriaPołączenie przychodzące z sieci komórkowej50 6f c5 82 c4 85 63 7a 65 6e 69 65 20 70 72 7a 79 63 68 6f 64 7a c4 85 63 65 20 7a 20 73 69 65 63 69 20 6b 6f 6d c3 b3 72 6b 6f 77 65 6a42 zn / 46 B
kategoriaWiadomość SMS do sieci komórkowej57 69 61 64 6f 6d 6f c5 9b c4 87 20 53 4d 53 20 64 6f 20 73 69 65 63 69 20 6b 6f 6d c3 b3 72 6b 6f 77 65 6a33 zn / 36 B
kategoriaPołączenie do sieci komórkowej50 6f c5 82 c4 85 63 7a 65 6e 69 65 20 64 6f 20 73 69 65 63 69 20 6b 6f 6d c3 b3 72 6b 6f 77 65 6a30 zn / 33 B

Tabela: mvno_kategorie_slownik

KolumnaTekst (jak widzi PHP)HEX bajtówDługość
nazwa_plInne usługi49 6e 6e 65 20 75 73 c5 82 75 67 6911 zn / 12 B
nazwa_plWiadomości MMS57 69 61 64 6f 6d 6f c5 9b 63 69 20 4d 4d 5314 zn / 15 B
nazwa_plPoczta głosowa (voicemail)50 6f 63 7a 74 61 20 67 c5 82 6f 73 6f 77 61 20 28 76 6f 69 63 65 6d 61 69 6c 2926 zn / 27 B

Tabela: swiatlowod

KolumnaTekst (jak widzi PHP)HEX bajtówDługość
miejscowoscGrodków47 72 6f 64 6b c3 b3 777 zn / 8 B
imieŻanetac5 bb 61 6e 65 74 616 zn / 7 B
adresStarczówek 7453 74 61 72 63 7a c3 b3 77 65 6b 20 37 3413 zn / 14 B
miejscowoscZiębice5a 69 c4 99 62 69 63 657 zn / 8 B
miejscowoscGrodków47 72 6f 64 6b c3 b3 777 zn / 8 B

Tabela: tauronbsa

KolumnaTekst (jak widzi PHP)HEX bajtówDługość
wojewodztwomałopolskie6d 61 c5 82 6f 70 6f 6c 73 6b 69 6511 zn / 12 B
powiatbocheński62 6f 63 68 65 c5 84 73 6b 699 zn / 10 B
wojewodztwomałopolskie6d 61 c5 82 6f 70 6f 6c 73 6b 69 6511 zn / 12 B
powiatbocheński62 6f 63 68 65 c5 84 73 6b 699 zn / 10 B
wojewodztwomałopolskie6d 61 c5 82 6f 70 6f 6c 73 6b 69 6511 zn / 12 B
powiatbocheński62 6f 63 68 65 c5 84 73 6b 699 zn / 10 B

Tabela: umowa_abonencka

KolumnaTekst (jak widzi PHP)HEX bajtówDługość
adres_instalacjiWojska Polskiego 1B/2 57-220 Ziębice57 6f 6a 73 6b 61 20 50 6f 6c 73 6b 69 65 67 6f 20 31 42 2f 32 20 35 37 2d 32 32 30 20 5a 69 c3 84 c2 99 62 69 63 6537 zn / 39 B
adres_instalacjiChełmońskiego 5 57-120 Wiązów43 68 65 c4 b9 c2 82 6d 6f c4 b9 c2 84 73 6b 69 65 67 6f 20 35 20 35 37 2d 31 32 30 20 57 69 c3 84 c2 85 7a c4 82 c5 82 7733 zn / 41 B
adres_instalacjiPrzemysłowa 20C/1 57-220 Ziębice50 72 7a 65 6d 79 73 c4 b9 c2 82 6f 77 61 20 32 30 43 2f 31 20 35 37 2d 32 32 30 20 5a 69 c3 84 c2 99 62 69 63 6534 zn / 38 B

Tabela: umowa_abonencka_podpisana

KolumnaTekst (jak widzi PHP)HEX bajtówDługość
dane_umowy{"operator":{"nazwa":"MultimediaHD Emil Fatyga","adres":"ul. Wojska Polskiego 1b\/2, 57-220 Ziębice","nip":"8871737274","uke":"12121","email":"biuro@multimediahd.pl"},"abonent":{"user_id":1,"nazwa":"Emil Fatyga","pesel":"89052807810","nip":"8871737274","dowod":"ALG185395","telefon":"725857833","email":"admin@multimediahd.pl"},"data_podpisania":"20.06.2015","data_aktywacji":"20.06.2015","adres_instalacji":"Wojska Polskiego 1B\/2 57-220 Ziębice","oplata_aktywacyjna":"249,00","koszty_dodatkowe":"59,00","okres_umowy":"24","informacje_dodatkowe":"Deco M4","nr_konta":"PL47114020040000370276845419","pppoe_login":"admin","pppoe_haslo":"volt11","uslugi_html":"\n\t\t\t\t\t<tbody><tr><th>Usługa<\/th><th>Szczegóły<\/th><th class=\"text-right\" id=\"ua-th-oplata\">Opłata miesięczna<\/th><\/tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>Telewizja IPTV<\/td>\n\t\t\t\t\t\t<td>Pakiet: Własny<\/td>\n\t\t\t\t\t\t<td class=\"text-right\">0,00 zł<\/td>\n\t\t\t\t\t<\/tr>\n\t\t\t\t\t<tr style=\"font-weight:bold;background:#f2f2f2;\">\n\t\t\t\t\t\t<td colspan=\"2\">RAZEM OPŁATA ABONAMENTOWA (brutto)<\/td>\n\t\t\t\t\t\t<td class=\"text-right\" id=\"ua-cena-razem\">0,00 zł<\/td>\n\t\t\t\t\t<\/tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td colspan=\"2\" style=\"font-size:11px;color:#777;\" id=\"ua-cena-doplata\"><\/td>\n\t\t\t\t\t\t<td><\/td>\n\t\t\t\t\t<\/tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td colspan=\"2\">Jednorazowa opłata aktywacyjna \/ instalacyjna<\/td>\n\t\t\t\t\t\t<td class=\"text-right\">\n\t\t\t\t\t\t\t<input type=\"text\" id=\"ua-oplata-aktywacyjna\" class=\"ua-editable text-right\" style=\"width:80px;\" value=\"249,00\" title=\"Opłata aktywacyjna — edytowalne\"> zł\n\t\t\t\t\t\t<\/td>\n\t\t\t\t\t<\/tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td colspan=\"2\">Koszty dodatkowe<\/td>\n\t\t\t\t\t\t<td class=\"text-right\">\n\t\t\t\t\t\t\t<input type=\"text\" id=\"ua-koszty-dodatkowe\" class=\"ua-editable text-right\" style=\"width:80px;\" value=\"59,00\" title=\"Koszty dodatkowe — edytowalne\"> zł\n\t\t\t\t\t\t<\/td>\n\t\t\t\t\t<\/tr>\n\t\t\t\t<\/tbody>","naglowek_oplata":"Opłata miesięczna","cena_razem":"0,00 zł","cena_doplata_opis":""}7b 22 6f 70 65 72 61 74 6f 72 22 3a 7b 22 6e 61 7a 77 61 22 3a 22 4d 75 6c 74 69 6d 65 64 69 61 48 44 20 45 6d 69 6c 20 46 61 74 79 67 61 22 2c 22 61 64 72 65 73 22 3a 22 75 6c 2e 20 57 6f 6a 73 6b 61 20 50 6f 6c 73 6b 69 65 67 6f 20 31 62 5c 2f 32 2c 20 35 37 2d 32 32 30 20 5a 69 c3 84 c2 99 62 69 63 65 22 2c 22 6e 69 70 22 3a 22 38 38 37 31 37 33 37 32 37 34 22 2c 22 75 6b 65 22 3a 22 31 32 31 32 31 22 2c 22 65 6d 61 69 6c 22 3a 22 62 69 75 72 6f 40 6d 75 6c 74 69 6d 65 64 69 61 68 64 2e 70 6c 22 7d 2c 22 61 62 6f 6e 65 6e 74 22 3a 7b 22 75 73 65 72 5f 69 64 22 3a 31 2c 22 6e 61 7a 77 61 22 3a 22 45 6d 69 6c 20 46 61 74 79 67 61 22 2c 22 70 65 73 65 6c 22 3a 22 38 39 30 35 32 38 30 37 38 31 30 22 2c 22 6e 69 70 22 3a 22 38 38 37 31 37 33 37 32 37 34 22 2c 22 64 6f 77 6f 64 22 3a 22 41 4c 47 31 38 35 33 39 35 22 2c 22 74 65 6c 65 66 6f 6e 22 3a 22 37 32 35 38 35 37 38 33 33 22 2c 22 65 6d 61 69 6c 22 3a 22 61 64 6d 69 6e 40 6d 75 6c 74 69 6d 65 64 69 61 68 64 2e 70 6c 22 7d 2c 22 64 61 74 61 5f 70 6f 64 70 69 73 61 6e 69 61 22 3a 22 32 30 2e 30 36 2e 32 30 31 35 22 2c 22 64 61 74 61 5f 61 6b 74 79 77 61 63 6a 69 22 3a 22 32 30 2e 30 36 2e 32 30 31 35 22 2c 22 61 64 72 65 73 5f 69 6e 73 74 61 6c 61 63 6a 69 22 3a 22 57 6f 6a 73 6b 61 20 50 6f 6c 73 6b 69 65 67 6f 20 31 42 5c 2f 32 20 35 37 2d 32 32 30 20 5a 69 c3 84 c2 99 62 69 63 65 22 2c 22 6f 70 6c 61 74 61 5f 61 6b 74 79 77 61 63 79 6a 6e 61 22 3a 22 32 34 39 2c 30 30 22 2c 22 6b 6f 73 7a 74 79 5f 64 6f 64 61 74 6b 6f 77 65 22 3a 22 35 39 2c 30 30 22 2c 22 6f 6b 72 65 73 5f 75 6d 6f 77 79 22 3a 22 32 34 22 2c 22 69 6e 66 6f 72 6d 61 63 6a 65 5f 64 6f 64 61 74 6b 6f 77 65 22 3a 22 44 65 63 6f 20 4d 34 22 2c 22 6e 72 5f 6b 6f 6e 74 61 22 3a 22 50 4c 34 37 31 31 34 30 32 30 30 34 30 30 30 30 33 37 30 32 37 36 38 34 35 34 31 39 22 2c 22 70 70 70 6f 65 5f 6c 6f 67 69 6e 22 3a 22 61 64 6d 69 6e 22 2c 22 70 70 70 6f 65 5f 68 61 73 6c 6f 22 3a 22 76 6f 6c 74 31 31 22 2c 22 75 73 6c 75 67 69 5f 68 74 6d 6c 22 3a 22 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 62 6f 64 79 3e 3c 74 72 3e 3c 74 68 3e 55 73 c4 b9 c2 82 75 67 61 3c 5c 2f 74 68 3e 3c 74 68 3e 53 7a 63 7a 65 67 c4 82 c5 82 c4 b9 c2 82 79 3c 5c 2f 74 68 3e 3c 74 68 20 63 6c 61 73 73 3d 5c 22 74 65 78 74 2d 72 69 67 68 74 5c 22 20 69 64 3d 5c 22 75 61 2d 74 68 2d 6f 70 6c 61 74 61 5c 22 3e 4f 70 c4 b9 c2 82 61 74 61 20 6d 69 65 73 69 c3 84 c2 99 63 7a 6e 61 3c 5c 2f 74 68 3e 3c 5c 2f 74 72 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 72 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 3e 54 65 6c 65 77 69 7a 6a 61 20 49 50 54 56 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 3e 50 61 6b 69 65 74 3a 20 57 c4 b9 c2 82 61 73 6e 79 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 20 63 6c 61 73 73 3d 5c 22 74 65 78 74 2d 72 69 67 68 74 5c 22 3e 30 2c 30 30 20 7a c4 b9 c2 82 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 5c 2f 74 72 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 72 20 73 74 79 6c 65 3d 5c 22 66 6f 6e 74 2d 77 65 69 67 68 74 3a 62 6f 6c 64 3b 62 61 63 6b 67 72 6f 75 6e 64 3a 23 66 32 66 32 66 32 3b 5c 22 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 20 63 6f 6c 73 70 61 6e 3d 5c 22 32 5c 22 3e 52 41 5a 45 4d 20 4f 50 c4 b9 c2 81 41 54 41 20 41 42 4f 4e 41 4d 45 4e 54 4f 57 41 20 28 62 72 75 74 74 6f 29 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 20 63 6c 61 73 73 3d 5c 22 74 65 78 74 2d 72 69 67 68 74 5c 22 20 69 64 3d 5c 22 75 61 2d 63 65 6e 61 2d 72 61 7a 65 6d 5c 22 3e 30 2c 30 30 20 7a c4 b9 c2 82 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 5c 2f 74 72 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 72 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 20 63 6f 6c 73 70 61 6e 3d 5c 22 32 5c 22 20 73 74 79 6c 65 3d 5c 22 66 6f 6e 74 2d 73 69 7a 65 3a 31 31 70 78 3b 63 6f 6c 6f 72 3a 23 37 37 37 3b 5c 22 20 69 64 3d 5c 22 75 61 2d 63 65 6e 61 2d 64 6f 70 6c 61 74 61 5c 22 3e 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 3e 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 5c 2f 74 72 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 72 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 20 63 6f 6c 73 70 61 6e 3d 5c 22 32 5c 22 3e 4a 65 64 6e 6f 72 61 7a 6f 77 61 20 6f 70 c4 b9 c2 82 61 74 61 20 61 6b 74 79 77 61 63 79 6a 6e 61 20 5c 2f 20 69 6e 73 74 61 6c 61 63 79 6a 6e 61 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 20 63 6c 61 73 73 3d 5c 22 74 65 78 74 2d 72 69 67 68 74 5c 22 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 69 6e 70 75 74 20 74 79 70 65 3d 5c 22 74 65 78 74 5c 22 20 69 64 3d 5c 22 75 61 2d 6f 70 6c 61 74 61 2d 61 6b 74 79 77 61 63 79 6a 6e 61 5c 22 20 63 6c 61 73 73 3d 5c 22 75 61 2d 65 64 69 74 61 62 6c 65 20 74 65 78 74 2d 72 69 67 68 74 5c 22 20 73 74 79 6c 65 3d 5c 22 77 69 64 74 68 3a 38 30 70 78 3b 5c 22 20 76 61 6c 75 65 3d 5c 22 32 34 39 2c 30 30 5c 22 20 74 69 74 6c 65 3d 5c 22 4f 70 c4 b9 c2 82 61 74 61 20 61 6b 74 79 77 61 63 79 6a 6e 61 20 c3 a2 c2 80 c2 94 20 65 64 79 74 6f 77 61 6c 6e 65 5c 22 3e 20 7a c4 b9 c2 82 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 5c 2f 74 72 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 72 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 20 63 6f 6c 73 70 61 6e 3d 5c 22 32 5c 22 3e 4b 6f 73 7a 74 79 20 64 6f 64 61 74 6b 6f 77 65 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 20 63 6c 61 73 73 3d 5c 22 74 65 78 74 2d 72 69 67 68 74 5c 22 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 69 6e 70 75 74 20 74 79 70 65 3d 5c 22 74 65 78 74 5c 22 20 69 64 3d 5c 22 75 61 2d 6b 6f 73 7a 74 79 2d 64 6f 64 61 74 6b 6f 77 65 5c 22 20 63 6c 61 73 73 3d 5c 22 75 61 2d 65 64 69 74 61 62 6c 65 20 74 65 78 74 2d 72 69 67 68 74 5c 22 20 73 74 79 6c 65 3d 5c 22 77 69 64 74 68 3a 38 30 70 78 3b 5c 22 20 76 61 6c 75 65 3d 5c 22 35 39 2c 30 30 5c 22 20 74 69 74 6c 65 3d 5c 22 4b 6f 73 7a 74 79 20 64 6f 64 61 74 6b 6f 77 65 20 c3 a2 c2 80 c2 94 20 65 64 79 74 6f 77 61 6c 6e 65 5c 22 3e 20 7a c4 b9 c2 82 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 5c 2f 74 72 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 3c 5c 2f 74 62 6f 64 79 3e 22 2c 22 6e 61 67 6c 6f 77 65 6b 5f 6f 70 6c 61 74 61 22 3a 22 4f 70 c4 b9 c2 82 61 74 61 20 6d 69 65 73 69 c3 84 c2 99 63 7a 6e 61 22 2c 22 63 65 6e 61 5f 72 61 7a 65 6d 22 3a 22 30 2c 30 30 20 7a c4 b9 c2 82 22 2c 22 63 65 6e 61 5f 64 6f 70 6c 61 74 61 5f 6f 70 69 73 22 3a 22 22 7d2147 zn / 2189 B
dane_umowy{"operator":{"nazwa":"MultimediaHD Emil Fatyga","adres":"ul. Wojska Polskiego 1b\/2, 57-220 Ziębice","nip":"8871737274","uke":"12121","email":"biuro@multimediahd.pl"},"abonent":{"user_id":376,"nazwa":"Bogdan Klecki","pesel":"68102310159","nip":"","dowod":"CDR794369","telefon":"691126478","email":"kleckibogdan2310@gmail.com"},"data_podpisania":"30.06.2026","data_aktywacji":"30.06.2026","adres_instalacji":"Radzikowicka 8\/3 48-300 Goświnowice","oplata_aktywacyjna":"149,00","koszty_dodatkowe":"0,00","okres_umowy":"24","informacje_dodatkowe":"Nazwa sieci Wi-Fi SilesiaMobile_547C48\\nHasło WiFi:6H3YX45868","nr_konta":"PL47114020040000370276845419","pppoe_login":"goswinowiceradzikowicka8\/3","pppoe_haslo":"Klecki8\/3!@123","uslugi_html":"\n\t\t\t\t\t<tbody><tr><th>Usługa<\/th><th>Szczegóły<\/th><th class=\"text-right\" id=\"ua-th-oplata\">Opłata miesięczna<\/th><\/tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>SilesiaMobile (MVNO)<\/td>\n\t\t\t\t\t\t<td>Liczba aktywnych kart SIM: 1<\/td>\n\t\t\t\t\t\t<td class=\"text-right\" id=\"ua-cena-mvno\">109,00 zł<\/td>\n\t\t\t\t\t<\/tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><\/td>\n\t\t\t\t\t\t<td style=\"color:#555;\">\n\t\t\t\t\t\t\t660-788-302\t\t\t\t\t\t\t <span style=\"color:#888;font-size:11px;\">(100\/10)<\/span>\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t<td><\/td>\n\t\t\t\t\t<\/tr>\n\t\t\t\t\t<!-- Wiersz Uslugi Testowej - pokazywany tylko gdy okres = testowy_14 -->\n\t\t\t\t\t<tr id=\"ua-row-testowy\" style=\"display:none;\">\n\t\t\t\t\t\t<td>Usługa Testowa 14 dni<\/td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\tMVNO:&nbsp;<input type=\"text\" id=\"ua-testowy-mvno\" class=\"ua-editable\" style=\"width:130px;\" placeholder=\"nr telefonu\" title=\"Numer MVNO — edytowalne\" oninput=\"uaLookupTaryfa(this.value)\">\n\t\t\t\t\t\t\t<span id=\"ua-testowy-taryfa\" style=\"font-size:11px;color:#888;margin-left:4px;\"><\/span>\n\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t<td class=\"text-right\">0,00 zł<\/td>\n\t\t\t\t\t<\/tr>\n\t\t\t\t\t<script>\n\t\t\t\t\t\/\/ Mapa numer→taryfa preładowana z bazy dla tego abonenta (MVNO aktywne karty)\n\t\t\t\t\tvar uaMvnoTaryfy = {\"660788302\":\"100\\\/10\",\"660-788-302\":\"100\\\/10\"};\n\t\t\t\t\tfunction uaLookupTaryfa(nr) {\n\t\t\t\t\t\tvar span = document.getElementById('ua-testowy-taryfa');\n\t\t\t\t\t\tif (!span) return;\n\t\t\t\t\t\t\/\/ Normalizuj numer: usuń myslniki i spacje\n\t\t\t\t\t\tvar nr_clean = nr.replace(\/[\\s\\-]\/g, '');\n\t\t\t\t\t\tvar taryfa = uaMvnoTaryfy[nr_clean] || uaMvnoTaryfy[nr] || '';\n\t\t\t\t\t\tspan.textContent = taryfa ? '(' + taryfa + ')' : '';\n\t\t\t\t\t}\n\t\t\t\t\t<\/script>\n\t\t\t\t\t<tr style=\"font-weight:bold;background:#f2f2f2;\">\n\t\t\t\t\t\t<td colspan=\"2\">RAZEM OPŁATA ABONAMENTOWA (brutto)<\/td>\n\t\t\t\t\t\t<td class=\"text-right\" id=\"ua-cena-razem\">109,00 zł<\/td>\n\t\t\t\t\t<\/tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td colspan=\"2\" style=\"font-size:11px;color:#777;\" id=\"ua-cena-doplata\"><span style=\"color:#3c763d;\">−10,00 zł (zgoda na fakturę e-mail\/ICU)<\/span> &nbsp;|&nbsp; <span style=\"color:#3c763d;\">−10,00 zł (zgody marketingowe)<\/span><\/td>\n\t\t\t\t\t\t<td><\/td>\n\t\t\t\t\t<\/tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td colspan=\"2\">Jednorazowa opłata aktywacyjna \/ instalacyjna<\/td>\n\t\t\t\t\t\t<td class=\"text-right\">\n\t\t\t\t\t\t\t<input type=\"text\" id=\"ua-oplata-aktywacyjna\" class=\"ua-editable text-right\" style=\"width:80px;\" value=\"149,00\" title=\"Opłata aktywacyjna — edytowalne\"> zł\n\t\t\t\t\t\t<\/td>\n\t\t\t\t\t<\/tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td colspan=\"2\">Koszty dodatkowe<\/td>\n\t\t\t\t\t\t<td class=\"text-right\">\n\t\t\t\t\t\t\t<input type=\"text\" id=\"ua-koszty-dodatkowe\" class=\"ua-editable text-right\" style=\"width:80px;\" value=\"0,00\" title=\"Koszty dodatkowe — edytowalne\"> zł\n\t\t\t\t\t\t<\/td>\n\t\t\t\t\t<\/tr>\n\t\t\t\t<\/tbody>","naglowek_oplata":"Opłata miesięczna","cena_razem":"109,00 zł","cena_doplata_opis":"−10,00 zł (zgoda na fakturę e-mail\/ICU)  |  −10,00 zł (zgody marketingowe)","protokol_html":"<table style=\"width:100%;border-collapse:collapse;font-size:12px;\"><tr><th style=\"border:1px solid #999;padding:4px;\">Nazwa<\/th><th style=\"border:1px solid #999;padding:4px;\">Wartość<\/th><th style=\"border:1px solid #999;padding:4px;\">Identyfikator<\/th><\/tr><tr><td style=\"border:1px solid #999;padding:4px;\">ZTE MC888C<\/td><td style=\"border:1px solid #999;padding:4px;\">899<\/td><td style=\"border:1px solid #999;padding:4px;\">866378071646114<\/td><\/tr><\/table>","testowy_mvno":"","zgody":[1,1,1,1,1,1]}7b 22 6f 70 65 72 61 74 6f 72 22 3a 7b 22 6e 61 7a 77 61 22 3a 22 4d 75 6c 74 69 6d 65 64 69 61 48 44 20 45 6d 69 6c 20 46 61 74 79 67 61 22 2c 22 61 64 72 65 73 22 3a 22 75 6c 2e 20 57 6f 6a 73 6b 61 20 50 6f 6c 73 6b 69 65 67 6f 20 31 62 5c 2f 32 2c 20 35 37 2d 32 32 30 20 5a 69 c3 84 c2 99 62 69 63 65 22 2c 22 6e 69 70 22 3a 22 38 38 37 31 37 33 37 32 37 34 22 2c 22 75 6b 65 22 3a 22 31 32 31 32 31 22 2c 22 65 6d 61 69 6c 22 3a 22 62 69 75 72 6f 40 6d 75 6c 74 69 6d 65 64 69 61 68 64 2e 70 6c 22 7d 2c 22 61 62 6f 6e 65 6e 74 22 3a 7b 22 75 73 65 72 5f 69 64 22 3a 33 37 36 2c 22 6e 61 7a 77 61 22 3a 22 42 6f 67 64 61 6e 20 4b 6c 65 63 6b 69 22 2c 22 70 65 73 65 6c 22 3a 22 36 38 31 30 32 33 31 30 31 35 39 22 2c 22 6e 69 70 22 3a 22 22 2c 22 64 6f 77 6f 64 22 3a 22 43 44 52 37 39 34 33 36 39 22 2c 22 74 65 6c 65 66 6f 6e 22 3a 22 36 39 31 31 32 36 34 37 38 22 2c 22 65 6d 61 69 6c 22 3a 22 6b 6c 65 63 6b 69 62 6f 67 64 61 6e 32 33 31 30 40 67 6d 61 69 6c 2e 63 6f 6d 22 7d 2c 22 64 61 74 61 5f 70 6f 64 70 69 73 61 6e 69 61 22 3a 22 33 30 2e 30 36 2e 32 30 32 36 22 2c 22 64 61 74 61 5f 61 6b 74 79 77 61 63 6a 69 22 3a 22 33 30 2e 30 36 2e 32 30 32 36 22 2c 22 61 64 72 65 73 5f 69 6e 73 74 61 6c 61 63 6a 69 22 3a 22 52 61 64 7a 69 6b 6f 77 69 63 6b 61 20 38 5c 2f 33 20 34 38 2d 33 30 30 20 47 6f c4 b9 c2 9b 77 69 6e 6f 77 69 63 65 22 2c 22 6f 70 6c 61 74 61 5f 61 6b 74 79 77 61 63 79 6a 6e 61 22 3a 22 31 34 39 2c 30 30 22 2c 22 6b 6f 73 7a 74 79 5f 64 6f 64 61 74 6b 6f 77 65 22 3a 22 30 2c 30 30 22 2c 22 6f 6b 72 65 73 5f 75 6d 6f 77 79 22 3a 22 32 34 22 2c 22 69 6e 66 6f 72 6d 61 63 6a 65 5f 64 6f 64 61 74 6b 6f 77 65 22 3a 22 4e 61 7a 77 61 20 73 69 65 63 69 20 57 69 2d 46 69 20 53 69 6c 65 73 69 61 4d 6f 62 69 6c 65 5f 35 34 37 43 34 38 5c 5c 6e 48 61 73 c4 b9 c2 82 6f 20 57 69 46 69 3a 36 48 33 59 58 34 35 38 36 38 22 2c 22 6e 72 5f 6b 6f 6e 74 61 22 3a 22 50 4c 34 37 31 31 34 30 32 30 30 34 30 30 30 30 33 37 30 32 37 36 38 34 35 34 31 39 22 2c 22 70 70 70 6f 65 5f 6c 6f 67 69 6e 22 3a 22 67 6f 73 77 69 6e 6f 77 69 63 65 72 61 64 7a 69 6b 6f 77 69 63 6b 61 38 5c 2f 33 22 2c 22 70 70 70 6f 65 5f 68 61 73 6c 6f 22 3a 22 4b 6c 65 63 6b 69 38 5c 2f 33 21 40 31 32 33 22 2c 22 75 73 6c 75 67 69 5f 68 74 6d 6c 22 3a 22 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 62 6f 64 79 3e 3c 74 72 3e 3c 74 68 3e 55 73 c4 b9 c2 82 75 67 61 3c 5c 2f 74 68 3e 3c 74 68 3e 53 7a 63 7a 65 67 c4 82 c5 82 c4 b9 c2 82 79 3c 5c 2f 74 68 3e 3c 74 68 20 63 6c 61 73 73 3d 5c 22 74 65 78 74 2d 72 69 67 68 74 5c 22 20 69 64 3d 5c 22 75 61 2d 74 68 2d 6f 70 6c 61 74 61 5c 22 3e 4f 70 c4 b9 c2 82 61 74 61 20 6d 69 65 73 69 c3 84 c2 99 63 7a 6e 61 3c 5c 2f 74 68 3e 3c 5c 2f 74 72 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 72 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 3e 53 69 6c 65 73 69 61 4d 6f 62 69 6c 65 20 28 4d 56 4e 4f 29 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 3e 4c 69 63 7a 62 61 20 61 6b 74 79 77 6e 79 63 68 20 6b 61 72 74 20 53 49 4d 3a 20 31 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 20 63 6c 61 73 73 3d 5c 22 74 65 78 74 2d 72 69 67 68 74 5c 22 20 69 64 3d 5c 22 75 61 2d 63 65 6e 61 2d 6d 76 6e 6f 5c 22 3e 31 30 39 2c 30 30 20 7a c4 b9 c2 82 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 5c 2f 74 72 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 72 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 3e 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 20 73 74 79 6c 65 3d 5c 22 63 6f 6c 6f 72 3a 23 35 35 35 3b 5c 22 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 36 36 30 2d 37 38 38 2d 33 30 32 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 20 3c 73 70 61 6e 20 73 74 79 6c 65 3d 5c 22 63 6f 6c 6f 72 3a 23 38 38 38 3b 66 6f 6e 74 2d 73 69 7a 65 3a 31 31 70 78 3b 5c 22 3e 28 31 30 30 5c 2f 31 30 29 3c 5c 2f 73 70 61 6e 3e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 3e 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 5c 2f 74 72 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 21 2d 2d 20 57 69 65 72 73 7a 20 55 73 6c 75 67 69 20 54 65 73 74 6f 77 65 6a 20 2d 20 70 6f 6b 61 7a 79 77 61 6e 79 20 74 79 6c 6b 6f 20 67 64 79 20 6f 6b 72 65 73 20 3d 20 74 65 73 74 6f 77 79 5f 31 34 20 2d 2d 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 72 20 69 64 3d 5c 22 75 61 2d 72 6f 77 2d 74 65 73 74 6f 77 79 5c 22 20 73 74 79 6c 65 3d 5c 22 64 69 73 70 6c 61 79 3a 6e 6f 6e 65 3b 5c 22 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 3e 55 73 c4 b9 c2 82 75 67 61 20 54 65 73 74 6f 77 61 20 31 34 20 64 6e 69 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 4d 56 4e 4f 3a 26 6e 62 73 70 3b 3c 69 6e 70 75 74 20 74 79 70 65 3d 5c 22 74 65 78 74 5c 22 20 69 64 3d 5c 22 75 61 2d 74 65 73 74 6f 77 79 2d 6d 76 6e 6f 5c 22 20 63 6c 61 73 73 3d 5c 22 75 61 2d 65 64 69 74 61 62 6c 65 5c 22 20 73 74 79 6c 65 3d 5c 22 77 69 64 74 68 3a 31 33 30 70 78 3b 5c 22 20 70 6c 61 63 65 68 6f 6c 64 65 72 3d 5c 22 6e 72 20 74 65 6c 65 66 6f 6e 75 5c 22 20 74 69 74 6c 65 3d 5c 22 4e 75 6d 65 72 20 4d 56 4e 4f 20 c3 a2 c2 80 c2 94 20 65 64 79 74 6f 77 61 6c 6e 65 5c 22 20 6f 6e 69 6e 70 75 74 3d 5c 22 75 61 4c 6f 6f 6b 75 70 54 61 72 79 66 61 28 74 68 69 73 2e 76 61 6c 75 65 29 5c 22 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 73 70 61 6e 20 69 64 3d 5c 22 75 61 2d 74 65 73 74 6f 77 79 2d 74 61 72 79 66 61 5c 22 20 73 74 79 6c 65 3d 5c 22 66 6f 6e 74 2d 73 69 7a 65 3a 31 31 70 78 3b 63 6f 6c 6f 72 3a 23 38 38 38 3b 6d 61 72 67 69 6e 2d 6c 65 66 74 3a 34 70 78 3b 5c 22 3e 3c 5c 2f 73 70 61 6e 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 20 63 6c 61 73 73 3d 5c 22 74 65 78 74 2d 72 69 67 68 74 5c 22 3e 30 2c 30 30 20 7a c4 b9 c2 82 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 5c 2f 74 72 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 73 63 72 69 70 74 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 2f 5c 2f 20 4d 61 70 61 20 6e 75 6d 65 72 c3 a2 c2 86 c2 92 74 61 72 79 66 61 20 70 72 65 c4 b9 c2 82 61 64 6f 77 61 6e 61 20 7a 20 62 61 7a 79 20 64 6c 61 20 74 65 67 6f 20 61 62 6f 6e 65 6e 74 61 20 28 4d 56 4e 4f 20 61 6b 74 79 77 6e 65 20 6b 61 72 74 79 29 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 76 61 72 20 75 61 4d 76 6e 6f 54 61 72 79 66 79 20 3d 20 7b 5c 22 36 36 30 37 38 38 33 30 32 5c 22 3a 5c 22 31 30 30 5c 5c 5c 2f 31 30 5c 22 2c 5c 22 36 36 30 2d 37 38 38 2d 33 30 32 5c 22 3a 5c 22 31 30 30 5c 5c 5c 2f 31 30 5c 22 7d 3b 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 66 75 6e 63 74 69 6f 6e 20 75 61 4c 6f 6f 6b 75 70 54 61 72 79 66 61 28 6e 72 29 20 7b 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 76 61 72 20 73 70 61 6e 20 3d 20 64 6f 63 75 6d 65 6e 74 2e 67 65 74 45 6c 65 6d 65 6e 74 42 79 49 64 28 27 75 61 2d 74 65 73 74 6f 77 79 2d 74 61 72 79 66 61 27 29 3b 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 69 66 20 28 21 73 70 61 6e 29 20 72 65 74 75 72 6e 3b 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 5c 2f 5c 2f 20 4e 6f 72 6d 61 6c 69 7a 75 6a 20 6e 75 6d 65 72 3a 20 75 73 75 c4 b9 c2 84 20 6d 79 73 6c 6e 69 6b 69 20 69 20 73 70 61 63 6a 65 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 76 61 72 20 6e 72 5f 63 6c 65 61 6e 20 3d 20 6e 72 2e 72 65 70 6c 61 63 65 28 5c 2f 5b 5c 5c 73 5c 5c 2d 5d 5c 2f 67 2c 20 27 27 29 3b 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 76 61 72 20 74 61 72 79 66 61 20 3d 20 75 61 4d 76 6e 6f 54 61 72 79 66 79 5b 6e 72 5f 63 6c 65 61 6e 5d 20 7c 7c 20 75 61 4d 76 6e 6f 54 61 72 79 66 79 5b 6e 72 5d 20 7c 7c 20 27 27 3b 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 73 70 61 6e 2e 74 65 78 74 43 6f 6e 74 65 6e 74 20 3d 20 74 61 72 79 66 61 20 3f 20 27 28 27 20 2b 20 74 61 72 79 66 61 20 2b 20 27 29 27 20 3a 20 27 27 3b 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 7d 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 5c 2f 73 63 72 69 70 74 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 72 20 73 74 79 6c 65 3d 5c 22 66 6f 6e 74 2d 77 65 69 67 68 74 3a 62 6f 6c 64 3b 62 61 63 6b 67 72 6f 75 6e 64 3a 23 66 32 66 32 66 32 3b 5c 22 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 20 63 6f 6c 73 70 61 6e 3d 5c 22 32 5c 22 3e 52 41 5a 45 4d 20 4f 50 c4 b9 c2 81 41 54 41 20 41 42 4f 4e 41 4d 45 4e 54 4f 57 41 20 28 62 72 75 74 74 6f 29 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 20 63 6c 61 73 73 3d 5c 22 74 65 78 74 2d 72 69 67 68 74 5c 22 20 69 64 3d 5c 22 75 61 2d 63 65 6e 61 2d 72 61 7a 65 6d 5c 22 3e 31 30 39 2c 30 30 20 7a c4 b9 c2 82 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 5c 2f 74 72 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 72 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 20 63 6f 6c 73 70 61 6e 3d 5c 22 32 5c 22 20 73 74 79 6c 65 3d 5c 22 66 6f 6e 74 2d 73 69 7a 65 3a 31 31 70 78 3b 63 6f 6c 6f 72 3a 23 37 37 37 3b 5c 22 20 69 64 3d 5c 22 75 61 2d 63 65 6e 61 2d 64 6f 70 6c 61 74 61 5c 22 3e 3c 73 70 61 6e 20 73 74 79 6c 65 3d 5c 22 63 6f 6c 6f 72 3a 23 33 63 37 36 33 64 3b 5c 22 3e c3 a2 c2 88 c2 92 31 30 2c 30 30 20 7a c4 b9 c2 82 20 28 7a 67 6f 64 61 20 6e 61 20 66 61 6b 74 75 72 c3 84 c2 99 20 65 2d 6d 61 69 6c 5c 2f 49 43 55 29 3c 5c 2f 73 70 61 6e 3e 20 26 6e 62 73 70 3b 7c 26 6e 62 73 70 3b 20 3c 73 70 61 6e 20 73 74 79 6c 65 3d 5c 22 63 6f 6c 6f 72 3a 23 33 63 37 36 33 64 3b 5c 22 3e c3 a2 c2 88 c2 92 31 30 2c 30 30 20 7a c4 b9 c2 82 20 28 7a 67 6f 64 79 20 6d 61 72 6b 65 74 69 6e 67 6f 77 65 29 3c 5c 2f 73 70 61 6e 3e 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 3e 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 5c 2f 74 72 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 72 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 20 63 6f 6c 73 70 61 6e 3d 5c 22 32 5c 22 3e 4a 65 64 6e 6f 72 61 7a 6f 77 61 20 6f 70 c4 b9 c2 82 61 74 61 20 61 6b 74 79 77 61 63 79 6a 6e 61 20 5c 2f 20 69 6e 73 74 61 6c 61 63 79 6a 6e 61 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 20 63 6c 61 73 73 3d 5c 22 74 65 78 74 2d 72 69 67 68 74 5c 22 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 69 6e 70 75 74 20 74 79 70 65 3d 5c 22 74 65 78 74 5c 22 20 69 64 3d 5c 22 75 61 2d 6f 70 6c 61 74 61 2d 61 6b 74 79 77 61 63 79 6a 6e 61 5c 22 20 63 6c 61 73 73 3d 5c 22 75 61 2d 65 64 69 74 61 62 6c 65 20 74 65 78 74 2d 72 69 67 68 74 5c 22 20 73 74 79 6c 65 3d 5c 22 77 69 64 74 68 3a 38 30 70 78 3b 5c 22 20 76 61 6c 75 65 3d 5c 22 31 34 39 2c 30 30 5c 22 20 74 69 74 6c 65 3d 5c 22 4f 70 c4 b9 c2 82 61 74 61 20 61 6b 74 79 77 61 63 79 6a 6e 61 20 c3 a2 c2 80 c2 94 20 65 64 79 74 6f 77 61 6c 6e 65 5c 22 3e 20 7a c4 b9 c2 82 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 5c 2f 74 72 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 72 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 20 63 6f 6c 73 70 61 6e 3d 5c 22 32 5c 22 3e 4b 6f 73 7a 74 79 20 64 6f 64 61 74 6b 6f 77 65 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 74 64 20 63 6c 61 73 73 3d 5c 22 74 65 78 74 2d 72 69 67 68 74 5c 22 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 69 6e 70 75 74 20 74 79 70 65 3d 5c 22 74 65 78 74 5c 22 20 69 64 3d 5c 22 75 61 2d 6b 6f 73 7a 74 79 2d 64 6f 64 61 74 6b 6f 77 65 5c 22 20 63 6c 61 73 73 3d 5c 22 75 61 2d 65 64 69 74 61 62 6c 65 20 74 65 78 74 2d 72 69 67 68 74 5c 22 20 73 74 79 6c 65 3d 5c 22 77 69 64 74 68 3a 38 30 70 78 3b 5c 22 20 76 61 6c 75 65 3d 5c 22 30 2c 30 30 5c 22 20 74 69 74 6c 65 3d 5c 22 4b 6f 73 7a 74 79 20 64 6f 64 61 74 6b 6f 77 65 20 c3 a2 c2 80 c2 94 20 65 64 79 74 6f 77 61 6c 6e 65 5c 22 3e 20 7a c4 b9 c2 82 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 5c 74 3c 5c 2f 74 64 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 5c 74 3c 5c 2f 74 72 3e 5c 6e 5c 74 5c 74 5c 74 5c 74 3c 5c 2f 74 62 6f 64 79 3e 22 2c 22 6e 61 67 6c 6f 77 65 6b 5f 6f 70 6c 61 74 61 22 3a 22 4f 70 c4 b9 c2 82 61 74 61 20 6d 69 65 73 69 c3 84 c2 99 63 7a 6e 61 22 2c 22 63 65 6e 61 5f 72 61 7a 65 6d 22 3a 22 31 30 39 2c 30 30 20 7a c4 b9 c2 82 22 2c 22 63 65 6e 61 5f 64 6f 70 6c 61 74 61 5f 6f 70 69 73 22 3a 22 c3 a2 c2 88 c2 92 31 30 2c 30 30 20 7a c4 b9 c2 82 20 28 7a 67 6f 64 61 20 6e 61 20 66 61 6b 74 75 72 c3 84 c2 99 20 65 2d 6d 61 69 6c 5c 2f 49 43 55 29 20 c3 82 c2 a0 7c c3 82 c2 a0 20 c3 a2 c2 88 c2 92 31 30 2c 30 30 20 7a c4 b9 c2 82 20 28 7a 67 6f 64 79 20 6d 61 72 6b 65 74 69 6e 67 6f 77 65 29 22 2c 22 70 72 6f 74 6f 6b 6f 6c 5f 68 74 6d 6c 22 3a 22 3c 74 61 62 6c 65 20 73 74 79 6c 65 3d 5c 22 77 69 64 74 68 3a 31 30 30 25 3b 62 6f 72 64 65 72 2d 63 6f 6c 6c 61 70 73 65 3a 63 6f 6c 6c 61 70 73 65 3b 66 6f 6e 74 2d 73 69 7a 65 3a 31 32 70 78 3b 5c 22 3e 3c 74 72 3e 3c 74 68 20 73 74 79 6c 65 3d 5c 22 62 6f 72 64 65 72 3a 31 70 78 20 73 6f 6c 69 64 20 23 39 39 39 3b 70 61 64 64 69 6e 67 3a 34 70 78 3b 5c 22 3e 4e 61 7a 77 61 3c 5c 2f 74 68 3e 3c 74 68 20 73 74 79 6c 65 3d 5c 22 62 6f 72 64 65 72 3a 31 70 78 20 73 6f 6c 69 64 20 23 39 39 39 3b 70 61 64 64 69 6e 67 3a 34 70 78 3b 5c 22 3e 57 61 72 74 6f c4 b9 c2 9b c3 84 c2 87 3c 5c 2f 74 68 3e 3c 74 68 20 73 74 79 6c 65 3d 5c 22 62 6f 72 64 65 72 3a 31 70 78 20 73 6f 6c 69 64 20 23 39 39 39 3b 70 61 64 64 69 6e 67 3a 34 70 78 3b 5c 22 3e 49 64 65 6e 74 79 66 69 6b 61 74 6f 72 3c 5c 2f 74 68 3e 3c 5c 2f 74 72 3e 3c 74 72 3e 3c 74 64 20 73 74 79 6c 65 3d 5c 22 62 6f 72 64 65 72 3a 31 70 78 20 73 6f 6c 69 64 20 23 39 39 39 3b 70 61 64 64 69 6e 67 3a 34 70 78 3b 5c 22 3e 5a 54 45 20 4d 43 38 38 38 43 3c 5c 2f 74 64 3e 3c 74 64 20 73 74 79 6c 65 3d 5c 22 62 6f 72 64 65 72 3a 31 70 78 20 73 6f 6c 69 64 20 23 39 39 39 3b 70 61 64 64 69 6e 67 3a 34 70 78 3b 5c 22 3e 38 39 39 3c 5c 2f 74 64 3e 3c 74 64 20 73 74 79 6c 65 3d 5c 22 62 6f 72 64 65 72 3a 31 70 78 20 73 6f 6c 69 64 20 23 39 39 39 3b 70 61 64 64 69 6e 67 3a 34 70 78 3b 5c 22 3e 38 36 36 33 37 38 30 37 31 36 34 36 31 31 34 3c 5c 2f 74 64 3e 3c 5c 2f 74 72 3e 3c 5c 2f 74 61 62 6c 65 3e 22 2c 22 74 65 73 74 6f 77 79 5f 6d 76 6e 6f 22 3a 22 22 2c 22 7a 67 6f 64 79 22 3a 5b 31 2c 31 2c 31 2c 31 2c 31 2c 31 5d 7d4587 zn / 4675 B

Tabela: user_mvno

KolumnaTekst (jak widzi PHP)HEX bajtówDługość
mvno_faktura_opisSilesiaMobile.pl [usługa telefonii]53 69 6c 65 73 69 61 4d 6f 62 69 6c 65 2e 70 6c 20 5b 75 73 c5 82 75 67 61 20 74 65 6c 65 66 6f 6e 69 69 5d35 zn / 36 B
mvno_faktura_opisSilesiaMobile.pl [usługa telefonii]53 69 6c 65 73 69 61 4d 6f 62 69 6c 65 2e 70 6c 20 5b 75 73 c5 82 75 67 61 20 74 65 6c 65 66 6f 6e 69 69 5d35 zn / 36 B
mvno_faktura_opisSilesiaMobile.pl [usługa internetu]53 69 6c 65 73 69 61 4d 6f 62 69 6c 65 2e 70 6c 20 5b 75 73 c5 82 75 67 61 20 69 6e 74 65 72 6e 65 74 75 5d35 zn / 36 B

Tabela: users

KolumnaTekst (jak widzi PHP)HEX bajtówDługość
user_koniec_umowynieokreślony6e 69 65 6f 6b 72 65 c5 9b 6c 6f 6e 7912 zn / 13 B
user_koniec_umowy_iptvnieokreślony6e 69 65 6f 6b 72 65 c5 9b 6c 6f 6e 7912 zn / 13 B
user_faktura_opis_telefonSilesiaMobile.pl [usługa mvno]53 69 6c 65 73 69 61 4d 6f 62 69 6c 65 2e 70 6c 20 5b 75 73 c5 82 75 67 61 20 6d 76 6e 6f 5d30 zn / 31 B
user_miejscowoscZiębice5a 69 c4 99 62 69 63 657 zn / 8 B
user_faktura_opisDostęp do Internetu [usługa telekomunikacyjna]44 6f 73 74 c4 99 70 20 64 6f 20 49 6e 74 65 72 6e 65 74 75 20 5b 75 73 c5 82 75 67 61 20 74 65 6c 65 6b 6f 6d 75 6e 69 6b 61 63 79 6a 6e 61 5d46 zn / 48 B
user_faktura_opis_iptvDostęp do Telewizji IPTV [usługa telekomunikacyjna]44 6f 73 74 c4 99 70 20 64 6f 20 54 65 6c 65 77 69 7a 6a 69 20 49 50 54 56 20 5b 75 73 c5 82 75 67 61 20 74 65 6c 65 6b 6f 6d 75 6e 69 6b 61 63 79 6a 6e 61 5d51 zn / 53 B
user_koniec_umowynieokreślony6e 69 65 6f 6b 72 65 c5 9b 6c 6f 6e 7912 zn / 13 B
user_koniec_umowy_iptvnieokreślony6e 69 65 6f 6b 72 65 c5 9b 6c 6f 6e 7912 zn / 13 B
user_miejscowoscZiębice5a 69 c4 99 62 69 63 657 zn / 8 B
user_faktura_opisDostęp do Internetu [usługa telekomunikacyjna]44 6f 73 74 c4 99 70 20 64 6f 20 49 6e 74 65 72 6e 65 74 75 20 5b 75 73 c5 82 75 67 61 20 74 65 6c 65 6b 6f 6d 75 6e 69 6b 61 63 79 6a 6e 61 5d46 zn / 48 B
user_nazwaMałgorzata Koprowska4d 61 c5 82 67 6f 72 7a 61 74 61 20 4b 6f 70 72 6f 77 73 6b 6120 zn / 21 B
user_koniec_umowynieokreślony6e 69 65 6f 6b 72 65 c5 9b 6c 6f 6e 7912 zn / 13 B
user_koniec_umowy_iptvnieokreślony6e 69 65 6f 6b 72 65 c5 9b 6c 6f 6e 7912 zn / 13 B
user_miejscowoscZiębice5a 69 c4 99 62 69 63 657 zn / 8 B
user_faktura_opisDostęp do Internetu [usługa telekomunikacyjna]44 6f 73 74 c4 99 70 20 64 6f 20 49 6e 74 65 72 6e 65 74 75 20 5b 75 73 c5 82 75 67 61 20 74 65 6c 65 6b 6f 6d 75 6e 69 6b 61 63 79 6a 6e 61 5d46 zn / 48 B

Tabela: v_mvno_kat_typy

KolumnaTekst (jak widzi PHP)HEX bajtówDługość
kategoria_nazwaPołączenie przychodzące z sieci komórkowej50 6f c5 82 c4 85 63 7a 65 6e 69 65 20 70 72 7a 79 63 68 6f 64 7a c4 85 63 65 20 7a 20 73 69 65 63 69 20 6b 6f 6d c3 b3 72 6b 6f 77 65 6a42 zn / 46 B
kategoria_nazwaWiadomość SMS do sieci komórkowej57 69 61 64 6f 6d 6f c5 9b c4 87 20 53 4d 53 20 64 6f 20 73 69 65 63 69 20 6b 6f 6d c3 b3 72 6b 6f 77 65 6a33 zn / 36 B
kategoria_nazwaPołączenie do sieci komórkowej50 6f c5 82 c4 85 63 7a 65 6e 69 65 20 64 6f 20 73 69 65 63 69 20 6b 6f 6d c3 b3 72 6b 6f 77 65 6a30 zn / 33 B

4. Test konwersji na żywych danych

Tabela: umowa_abonencka, kolumna: adres_instalacji

MetodaWynikHEX
OryginałWojska Polskiego 1B/2 57-220 Ziębice57 6F 6A 73 6B 61 20 50 6F 6C 73 6B 69 65 67 6F 20 31 42 2F 32 20 35 37 2D 32 32 30 20 5A 69 C3 84 C2 99 62 69 63 65
BINARY CONVERT latin1→utf8mb4Wojska Polskiego 1B/2 57-220 Zi57 6F 6A 73 6B 61 20 50 6F 6C 73 6B 69 65 67 6F 20 31 42 2F 32 20 35 37 2D 32 32 30 20 5A 69
CONVERT utf8mb4Wojska Polskiego 1B/2 57-220 Ziębice
CONVERT BINARY utf8mb4Wojska Polskiego 1B/2 57-220 Ziębice

⚠️ Usuń plik po diagnostyce!