Does PG Support Unicode on Windows?
Is there any truth to what this guy is saying?
On the other hand, Postgresql claims that "Windows
does not support
Unicode" and you can't have Unicode fields on
postgresql on Windows.
This is a big mistake. See:
http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html
What do you mean "a big mistake"? By Microsoft? Or
PostgreSQL?
The "Big mistake" is in the Postgresql FAQ in
saying that Windows
doesn't support Unicode. XP supports Unicode very
well indeed.
The FAQ I referenced prattles on about Slovenian
code pages,
of all things. Windows "Code pages" have been
superseded by
Unicode. If you go to http://msdn.microsoft.com
and search
for "Unicode" you get an eyeful.
Having defended the undefendable, however, I'd
like to know if
postgresql really still doesn't support Unicode on
windows, as
I plan to develop on WindowsXP and deploy on
Linux.
Warren Seltzer
Thread here:
http://www.ruby-forum.com/topic/3690#new
csn
__________________________________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com
On Nov 17, 2005, at 10:12 , CSN wrote:
Is there any truth to what this guy is saying?
[cut hard-to-read quotes regarding support for UTF8 in PostgreSQL on
Windows]
According to the release notes for 8.1:
http://www.postgresql.org/docs/8.1/interactive/release.html#RELEASE-8-1
----
* Allow the UTF8 encoding to work on Windows (Magnus)
This is done by mapping UTF8 to the Windows-native UTF16 implementation.
----
Michael Glaesemann
grzm myrealbox com
Is there any truth to what this guy is saying?
Yes, some. But not much.
On the other hand, Postgresql claims that "Windows
does not support
Unicode" and you can't have Unicode fields on
postgresql on Windows.
This is a big mistake. See:
http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html
What do you mean "a big mistake"? By Microsoft? Or
PostgreSQL?
We claim it doesn't support UTF8, and that is true. The misconception is in that PostgreSQL used to call UTF8 "UNICODE", with no discinctino. Windows suåpports UTF-16/UCCS-2.
That siad, we need to update the FAQ, because in 8.1 we *do* support unicode (UTF8) on win32. I'll go ahead and do that :)
//Magnus
Import Notes
Resolved by subject fallback