note 123797 added to function.odbc-connect
| From: | fr at freedom2ct dot com | Date: | Wed, 24 Apr 2019 13:14:18 +0000 |
| Subject: | note 123797 added to function.odbc-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-210664@lists.php.net to get a copy of this message | ||
Under Windows odbc_connect (and PDO ODBC) apparently uses the Windows locale to handle input and
output from e.g. MS access and MS SQL Server databases.
This causes lots of headaches if one is using other than ASCII characters.
Work-round solutions like utf8_encode and mb_convert both fails.
The solution I fund working is to perform the following changes to Windows
Control Panel > Region > Administrative > Change system locale
>Check '<i>Use Unicode UTF-8 for worldwide language support.</i>'
----
Server IP: 208.43.231.9
Probable Submitter: 185.85.3.142 (proxied: 62.198.47.124)
----
Manual Page -- http://php.net/manual/en/function.odbc-connect.php
Edit -- https://master.php.net/note/edit/123797
Del: integrated -- https://master.php.net/note/delete/123797/integrated
Del: useless -- https://master.php.net/note/delete/123797/useless
Del: bad code -- https://master.php.net/note/delete/123797/bad+code
Del: spam -- https://master.php.net/note/delete/123797/spam
Del: non-english -- https://master.php.net/note/delete/123797/non-english
Del: in docs -- https://master.php.net/note/delete/123797/in+docs
Del: other reasons-- https://master.php.net/note/delete/123797
Reject -- https://master.php.net/note/reject/123797
Search -- https://master.php.net/manage/user-notes.php