Skip to content

Commit 07d4f48

Browse files
dshanskefabaff
authored andcommitted
Update recorder.markdown (home-assistant#4321)
https://community.home-assistant.io/t/error-during-query-latin-1-codec-cant-encode-character/13630 - Better safe than sorry. Might as well always put this parameter in.
1 parent 2ad2ebc commit 07d4f48

File tree

1 file changed

+7
-7
lines changed

1 file changed

+7
-7
lines changed

source/_components/recorder.markdown

+7-7
Original file line numberDiff line numberDiff line change
@@ -105,15 +105,15 @@ action:
105105
| Database engine | `db_url` |
106106
| :---------------|:---------------------------------------------------------|
107107
| SQLite | `sqlite:///PATH/TO/DB_NAME` |
108-
| MariaDB | `mysql://SERVER_IP/DB_NAME` |
109-
| MariaDB         | `mysql://user:password@SERVER_IP/DB_NAME`       |
110-
| MySQL | `mysql://SERVER_IP/DB_NAME` |
111-
| MySQL           | `mysql://user:password@SERVER_IP/DB_NAME`       |
112-
| MySQL (pymysql) | `mysql+pymysql://SERVER_IP/DB_NAME` |
113-
| MySQL (pymysql) | `mysql+pymysql://user:password@SERVER_IP/DB_NAME` |
108+
| MariaDB | `mysql://SERVER_IP/DB_NAME?charset=utf8` |
109+
| MariaDB         | `mysql://user:password@SERVER_IP/DB_NAME?charset=utf8` |
110+
| MySQL | `mysql://SERVER_IP/DB_NAME?charset=utf8` |
111+
| MySQL           | `mysql://user:password@SERVER_IP/DB_NAME?charset=utf8` |
112+
| MySQL (pymysql) | `mysql+pymysql://SERVER_IP/DB_NAME?charset=utf8` |
113+
| MySQL (pymysql) | `mysql+pymysql://user:password@SERVER_IP/DB_NAME?charset=utf8` |
114114
| PostgreSQL | `postgresql://SERVER_IP/DB_NAME` |
115115
| PostgreSQL | `postgresql://scott:tiger@SERVER_IP/DB_NAME` |
116-
| MS SQL Server | `mssql+pymssql://user:pass@SERVER_IP/DB_NAME?charset=utf8` |
116+
| MS SQL Server | `mssql+pymssql://user:pass@SERVER_IP/DB_NAME?charset=utf8` |
117117

118118
## {% linkable_title Installation notes %}
119119

0 commit comments

Comments
 (0)