Re: [GENERAL] database encoding WIN -- Western or Cyrillic?
Peter Eisentraut wrote: Am Samstag, 12. Februar 2005 23:32 schrieb Preston Landers: If the postgresql encoding WIN is intended to be Cyrillic 1251, then it should be labeled as such in the docs to avoid confusion. Well, isn't it? You pointed to the place in the documentation yourself. Pardon me, but did you read the rest of my original email? The WIN encoding is labeled Windows CP1251. It doesn't say anything about Cyrillic or Russian, although WIN1256 is labeled Windows CP1256 (Arabic). Assuming that it is indeed supposed to be Cyrillic, that leaves the question of how to create a Postgresql database using Windows CP 1252 a.k.a. Western or ANSI. I remain mystified why the WIN encoding would default to a fairly obscure Cyrillic encoding considering most Russian users that I know are using either KOI8 or Unicode. It should at least be labeled Cyrllic to avoid confusion. I've seen a number of other websites that mistakenly referred to CP1251 Cyrillic when they really mean CP1252 Western. That's why I assumed this mistake was made here, especially since the word Cyrillic isn't mentioned on the PG doc page, and there is no indication of how to use CP1252. ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] database encoding WIN -- Western or Cyrillic?
Am Dienstag, 15. Februar 2005 00:09 schrieb Preston Landers: Assuming that it is indeed supposed to be Cyrillic, that leaves the question of how to create a Postgresql database using Windows CP 1252 a.k.a. Western or ANSI. You don't. That encoding is not supported (mostly because no one has bothered to implement it until now). I remain mystified why the WIN encoding would default to a fairly obscure Cyrillic encoding considering most Russian users that I know are using either KOI8 or Unicode. Legacy. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] database encoding WIN -- Western or Cyrillic?
Date: Tue, 15 Feb 2005 15:47:14 +0100 From: Peter Eisentraut [EMAIL PROTECTED] I remain mystified why the WIN encoding would default to a fairly obscure Cyrillic encoding considering most Russian users that I know are using either KOI8 or Unicode. Legacy. I'd not call it legacy _yet_ as it's as frequently used as about KOI8-R for WIN being the default on Windows for many apps. And since now the Win32 port is out, it's gonna be even more used. KOI8 was primarily used on Unixen. Unicode does not kick in yet much for Windows-minded people. -- Serguei A. Mokhov| /~\The ASCII Computer Science Department | \ / Ribbon Campaign Concordia University | XAgainst HTML Montreal, Quebec, Canada | / \ Email! ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] database encoding WIN -- Western or Cyrillic?
Am Samstag, 12. Februar 2005 23:32 schrieb Preston Landers: If the postgresql encoding WIN is intended to be Cyrillic 1251, then it should be labeled as such in the docs to avoid confusion. Well, isn't it? You pointed to the place in the documentation yourself. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])