Loading utf-8 encoded text into MySQL table
Try LOAD DATA INFILE ‘file’ IGNORE INTO TABLE table CHARACTER SET UTF8 FIELDS TERMINATED BY ‘;’ OPTIONALLY ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\n’
decode
How to decode base64 url in Python?
try s=”iEPX-SQWIR3p67lj_0zigSWTKHg” base64.urlsafe_b64decode(s + ‘=’ * (4 – len(s) % 4)) as it is written here
How can I unescape HTML character entities in Java?
I have used the Apache Commons StringEscapeUtils.unescapeHtml4() for this: Unescapes a string containing entity escapes to a string containing the actual Unicode characters corresponding to the escapes. Supports HTML 4.0 entities.
QR code (2D barcode) coding and decoding algorithms? [closed]
I have a colleague who worked on ZXing (“Zebra Crossing”). That’s got a fair variety of platform support.
What is the equivalent of JavaScript’s decodeURIcomponent in PHP?
urldecode() However you do not need to use it on $_REQUEST variables, which are already decoded automatically.
Data extraction from /Filter /FlateDecode PDF stream in PHP
Since you didn’t tell if you need to access one decompressed stream only or if you need all streams decompressed, I’ll suggest you a simple commandline tool which does it in one go for the complete PDF: Jay Berkenbilt’s qpdf. Example commandline: qpdf –qdf –object-streams=disable in.pdf out.pdf out.pdf can then be inspected in a text … Read more
Write Base64-encoded image to file
Assuming the image data is already in the format you want, you don’t need ImageIO at all – you just need to write the data to the file: // Note preferred way of declaring an array variable byte[] data = Base64.decodeBase64(crntImage); try (OutputStream stream = new FileOutputStream(“c:/decode/abc.bmp”)) { stream.write(data); } (I’m assuming you’re using Java … Read more
PHP replacing special characters like à->a, è->e
There’s a much easier way to do this, using iconv – from the user notes, this seems to be what you want to do: characters transliteration // PHP.net User notes <?php $string = “ʿABBĀSĀBĀD”; echo iconv(‘UTF-8’, ‘ISO-8859-1//TRANSLIT’, $string); // output: [nothing, and you get a notice] echo iconv(‘UTF-8’, ‘ISO-8859-1//IGNORE’, $string); // output: ABBSBD echo iconv(‘UTF-8’, … Read more
How to decode JSON in Flutter?
You will need to import dart:convert: import ‘dart:convert’; Inline example String rawJson = ‘{“name”:”Mary”,”age”:30}’; Map<String, dynamic> map = jsonDecode(rawJson); // import ‘dart:convert’; String name = map[‘name’]; int age = map[‘age’]; Person person = Person(name, age); Note: When I was doing this in VS Code for server side Dart I had to specify the type: Map<String, … Read more
Using an Alias in a WHERE clause
This is not possible directly, because chronologically, WHERE happens before SELECT, which always is the last step in the execution chain. You can do a sub-select and filter on it: SELECT * FROM ( SELECT A.identifier , A.name , TO_NUMBER(DECODE( A.month_no , 1, 200803 , 2, 200804 , 3, 200805 , 4, 200806 , 5, … Read more