Collation localization

From: Xela (abuse_at_yahoo.com)
Date: 04/17/04

  • Next message: Ken North: "Lists: XQuery engines, JDBC and ODBC drivers, OLE DB and .NET providers, DB2 extenders" 
    Date: Sat, 17 Apr 2004 18:15:51 +0200

        Hi !

    I would like to know how to have a collation done via jdbc in a locale that
    is not the one of the OS. Eg OS in english, and collation (via an order by
    clause) in german. Thanks a lot !

        Alexandre

  • Next message: Ken North: "Lists: XQuery engines, JDBC and ODBC drivers, OLE DB and .NET providers, DB2 extenders"

    Relevant Pages

    • Re: Moving Servers, Matching Collation
      ... If you change your default locale to U.S., that will be sufficient to have ... setup default to SQL_Latin1_General_CP1_CI_AS just as you say. ... When you reach the "Collation Settings" dialog, ... Microsoft SQL Server Support ...
      (microsoft.public.sqlserver.setup)
    • RE: Cannot determine default collation
      ... You can avoid the problem by changing your default system ... locale to a locale that isn't in the list in that article, reboot, then ... COLLATION command line parameter to setup (e.g. ... thread-index: AcRS8jxBIFmv0lEuTbeceZiciXUOYg== ...
      (microsoft.public.sqlserver.msde)
    • RE: unable to determine default collation
      ... You can avoid the problem by changing your default system ... locale to a locale that isn't in the list in that article, reboot, then ... COLLATION command line parameter to setup. ... thread-index: AcRS9OOXTYpyph85RCClAuJvdqXOgA== ...
      (microsoft.public.sqlserver.server)
    • Re: Alphabetical sorts
      ... Collation is almost always locale dependant. ... One day I needed collation that worked on Windows and Linux. ... '''Grab character encoding from locale name''' ... def setup_locale: ...
      (comp.lang.python)
    • RE: unable to determine system default collation (Installation Failed)
      ... or use the COLLATION command line parameter to specify a particular ... collation to use based on your system locale. ... Please reply to the newsgroup only - thanks. ... Hi, I've been installing MSDE on my WinXP Pro PC, without ...
      (microsoft.public.sqlserver.msde)