node-red-node-mysql - npm Package Compare versions

Comparing version 0.1.0 to 0.1.1

68-mysql.js

@@ -12,2 +12,3 @@
         this.tz = n.tz || "local";
+        this.charset = (n.charset || "UTF8_GENERAL_CI").toUpperCase();
 
@@ -45,3 +46,4 @@ this.connected = false;
                     multipleStatements: true,
-                    connectionLimit: 25
+                    connectionLimit: 25,
+                    charset: node.charset
                 });
@@ -141,3 +143,3 @@ }
                                     }
-                                return txt;
+                                    return txt;
                                 }.bind(this));
@@ -144,0 +146,0 @@ };

package.json

 {
     "name": "node-red-node-mysql",
-    "version": "0.1.0",
+    "version": "0.1.1",
     "description": "A Node-RED node to read and write to a MySQL database",
@@ -5,0 +5,0 @@ "dependencies": {

README.md

@@ -18,16 +18,22 @@ node-red-node-mysql
 
-This node uses the <b>query</b> operation against the configured database. This does allow both INSERTS and DELETES.
+This node uses the **query** operation against the configured database. This does allow both INSERTS and DELETES.
 
-By its very nature it allows SQL injection... so <i>be careful out there...</i>
+By its very nature it allows SQL injection... so *be careful out there...*
 
-The `msg.topic` must hold the <i>query</i> for the database, and the result is returned in `msg.payload`.
+The `msg.topic` must hold the *query* for the database, and the result is returned in `msg.payload`.
 
 Typically the returned payload will be an array of the result rows.
 
-If nothing is found for the key then <i>null</i> is returned.
+If nothing is found for the key then *null* is returned.
 
-The reconnect retry timeout in milliseconds can be changed by adding a line to <b>settings.js</b>
-    <pre>mysqlReconnectTime: 30000,</pre></p>
+The reconnect retry timeout in milliseconds can be changed by adding a line to **settings.js**
+```javascript
+mysqlReconnectTime: 30000,
+```
 
+The timezone can be set like GMT, EST5EDT, UTC, etc.
 
+The charset defaults to the "old" Mysql 3 byte UTF. If you need support for emojis etc then use UTF8MB4.
+
+
 Preparing Queries
@@ -50,5 +56,6 @@ -----
 ```
+
 Documentation
 -----
-    
+ 
 <a href="https://www.npmjs.com/package/mysql" target="_new">Documentation</a> of the used Node.js package    

New alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Fixed alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Improved metrics

Total package byte prevSize

14698

increased by4.99%

Lines of code

174

increased by1.16%

Number of lines in readme file

60

increased by13.21%

No dependency changes