Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Difference between PostgreSQL Unicode v ANSI drivers

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 . 





This post first appeared on Dba-ninja.com, please read the originial post: here

Share the post

Difference between PostgreSQL Unicode v ANSI drivers

×

Subscribe to Dba-ninja.com

Get updates delivered right to your inbox!

Thank you for your subscription

×