Results 1 to 2 of 2

Thread: Locale stuff

  1. #1
    Join Date
    Nov 2003
    Location
    Devon, UK
    Posts
    3

    Unanswered: Locale stuff

    Hi,

    You might just be able to save me downloading and installing SQL Server French...

    I'm having localization problems with some .NET code - and I might be able to solve the problem if I know how SQL is parsed in different locales. Say my table MyTable contains a float column FloatColumn. In English, I would say
    Code:
    SELECT * FROM MyTable WHERE FloatColumn = 2.3
    If my locale was, say for argument's sake, French, would I have to write
    Code:
    SELECT * FROM MyTable WHERE FloatColumn = 2,3
    ???

    Thanks for your help,
    T

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I prefer to dodge this bullet altogether, and make .NET do the work. Use a question mark in your query rather than a constant, and (if necessary) code the constant into your application. A bit messy, but it gets around the localization problems.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •