Re: ODBC Driver dsplay name
Hello,
Switching from SQL Server to PostgreSQL.
Installed Postgresql 11.8 successfully.
Need to install ODBC to connect from front end. When I install ODBC using stack builder <after installing PG>, I see the ODBC name < in ODBC data source administrator>
PostgresSQL ODBC Driver(ANSI)PostgresSQL ODBC Driver(UNICODE)
When I download psqlodbc from https://www.postgresql.org/ftp/odbc/versions/msi/and install ODBC I get the following names
PostgreSQL ANSIPostgreSQL Unicode
1. Is there any difference between two ?2. Since I dynamically construct DSN from front end, I need to get the same name in all machines. Is there any way to get the same name, < PostgreSQL ODBC Driver(ANSI) or PostgreSQL ODBC Driver(UNICODE), while installing from ODBC Driver downloaded from the above mentioned site ?
Happiness AlwaysBKR Sivaprakash
Import Notes
Reference msg id not found: 495836002.1632180.1599140562118.ref@mail.yahoo.com
On 2020-09-03 13:42:42 +0000, Siva postgres wrote:
When I download psqlodbc from https://www.postgresql.org/ftp/odbc/versions/msi/
and install ODBC I get the following namesPostgreSQL ANSI
PostgreSQL Unicode1. Is there any difference between two ?
The character encoding and therefore the set of characters you can use.
Always use PostgreSQL Unicode, unless you have (very old and arguably
broken) software which can't handle it.
hp
--
_ | Peter J. Holzer | Story must make more sense than reality.
|_|_) | |
| | | hjp@hjp.at | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"