Re: ODBC Driver dsplay name

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Re: ODBC Driver dsplay name

sivapostgres@yahoo.com
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)

and install ODBC I get the following names

PostgreSQL ANSI
PostgreSQL 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 Always
BKR Sivaprakash

Reply | Threaded
Open this post in threaded view
|

Re: ODBC Driver dsplay name

Peter J. Holzer
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 names
>
> PostgreSQL ANSI
> PostgreSQL Unicode
>
> 1.  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.
|_|_) |                    |
| |   | [hidden email]         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

signature.asc (849 bytes) Download Attachment