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 .
This is only a preview. Your comment has not yet been posted.
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.
Posted by: |