Re: More Code Page wierdness

If you change the code page of a server after installing applications on it then it is your job to re-install those applications and choose the correct locale.
Even M$ Sql Server will not automatically do this for you. It will throw an error / fail to execute any queries or procedures that depend upon the tempdb or master databases. The only way to fix is uninstall sql server and re-install using a compatible code page as it will not let you change the locale setting of the system databases such as tempdb and master.

Sql Server 2000 will also not warn you that the locale you have chosen does not match the operating system.

Perhaps 2003 is a little more smarter but I doubt it.

Mike

On Mon, Jan 10, 2005 at 09:46:46PM +0000, Simon Riggs wrote:
> Spent a few hours today diagnosing some errors on Win32 (on Windows
> Server 2003). These were, I think, wrongly identified as being Windows
> Installer problems, so I believe Magnus was chasing his tail also.
>
> The problem seemed to be code page related...
>
> If you set listen_addresses="*" then the pgsql server doesn't recognise
> this because * in one code page is different from * in another. It looks
> like a *, but it isn't...
>
> Setting listen_addresses to other valid values works just fine....tested
> with "localhost" using local TCP/IP connection; "localhost, 10.0.0.x"
> with access from 10.0.0.x...all working fine.
>
> Changing the default Language setting to match that of your keyboard is
> only a temporary workaround, since you can't be sure which code page is
> in use by any particular application or window. The only way to be sure
> is to set the default code page to the current locale and reboot, but
> I'm not sure that catches everything either once things have been
> edited.
>
> ISTM that the code page comments for psql are NOT the only ones that get
> effected by any code page mismatch. (and BTW, Windows 1252 is the UK
> default, not just the German - it is "Latin I"). ***Please put them back
> onto the Windows Installation page, where they should be***
>
> Anyway, main point here guys is deep code page wierdness is a wider
> problem than was at first thought...
>
> More testing required....and more on this particular problem to follow.
>
> I may suggest adding "any" as an option in the listen_addresses GUC, to
> ease the pain of this...but that seems too narrow a solution, much like
> the earlier suggestion to put the code page comments only on psql....
>
> These are definitely not Windows Installer problems because it is
> perfectly valid action to change the Language of a server, at least in
> Europe. The server should work, no matter what any installer
> did/does....just the same as the server knows not to start if the
> installer incorrectly set up the rights of the instance owning userid.
>
> --
> Best Regards, Simon Riggs
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly