Thread: Re: ODBC Driver dsplay name

Re: ODBC Driver dsplay name

From
Siva postgres
Date:
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

Re: ODBC Driver dsplay name

From
"Peter J. Holzer"
Date:
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.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

Attachment