Mercurial > hg > orthanc-book

comparison Sphinx/source/plugins/odbc.rst @ 789:2f70f622059b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
added odbc tip
author Alain Mazy <am@osimis.io>
date Wed, 24 Nov 2021 15:30:29 +0100
parents 37512473ffe9
children 1316bc62b5d5
comparison
equal deleted inserted replaced
788:8856bcfc561e 789:2f70f622059b
336 "IndexConnectionString" : "Driver={ODBC Driver 17 for SQL Server};Server=tcp:localhost,1433;Database=orthanctest;Uid=sa;Pwd=MyStrOngPa55word!", 336 "IndexConnectionString" : "Driver={ODBC Driver 17 for SQL Server};Server=tcp:localhost,1433;Database=orthanctest;Uid=sa;Pwd=MyStrOngPa55word!",
337 "StorageConnectionString" : "Driver={ODBC Driver 17 for SQL Server};Server=tcp:localhost,1433;Database=orthanctest;Uid=sa;Pwd=MyStrOngPa55word!" 337 "StorageConnectionString" : "Driver={ODBC Driver 17 for SQL Server};Server=tcp:localhost,1433;Database=orthanctest;Uid=sa;Pwd=MyStrOngPa55word!"
338 } 338 }
339 } 339 }
340 340
341 **Remark:** On Windows systems, we have noticed that the ODBC drivers character encoding
342 seems to depend on a system level configuration. This configuration needs to enforce UTF-8.
343 Therefore, it is advised to configure the system locale as follow:
344
345 .. image:: ../images/odbc-windows-system-locale.png
346 :align: center
347 :width: 600px
348
349 |
341 350
342 PostgreSQL 351 PostgreSQL
343 ^^^^^^^^^^ 352 ^^^^^^^^^^
344 353
345 1. Install the ``odbc-postgresql`` package. 354 1. Install the ``odbc-postgresql`` package.