Difference between PostgreSQL Unicode v ANSI drivers

23 May,2022 by Rambler

Question: Which should I use ?PostgreSQL drivers for Unicode v ANSI ?   These options appear when I attempt to configure am ODBC  DSN  for a connection to a PostgreSQL database.

Answer: Some background information  as both ANSI and Unicode represent encoding formats - but when adding the PostgreSQL drivers both AND ANSI appear , so which driver to use? Use Unicode unless your application is not Unicode compliant.

It's worth clearing up some confusion about the ANSI name - which is actually an organization (American National Standards Institute) rather than an encoding format. But it is also used synonymously as a character set  aka Window-1252 strangely not recognized by American National Standards Institute. 

ANSI is used to encode Latin alphabet - in the one-byte format aka fixed-width format. Whereas Unicode (there are different flavours)  has a variable length format . Most operating systems are now fully compliant with Unicode - and versions of Operating Systems that were ANSI  have reached there end-of-life versions.    

ANSI is  maintained to deal with backward compatible applications. There are legacy applications not programmed  for Unicode . 



 


Author: Rambler (http://www.dba-ninja.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Difference between PostgreSQL Unicode v ANSI drivers


dba-ninja.com