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
SELECT * FROM MyTable WHERE FloatColumn = 2.3

If my locale was, say for argument's sake, French, would I have to write
SELECT * FROM MyTable WHERE FloatColumn = 2,3
?

Thanks for your help,
TI 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

Locale not supported Error

I am using Vista and when I try to open one of the Business intelligence reports, I get error "Locale 16393 not supported". Any clue on this ?

Thanks

moving to SQL Reporting Services forum.

Locale ID

Is missing.. Any suggestions
More Info here .
Using SQL 2005.. Trying something like this :
Select * from myTable where freetext(*,'Drive',Language 1030) -- Lang.
Danish
Error saying that Locale ID is invalid. Every other language I've tried is
working.. Anybody ?
Regards
Bobby Henningsen
"Bobby Henningsen" <bobhen@.tiscali.dk> wrote in message
news:eJrjYs70FHA.1028@.TK2MSFTNGP12.phx.gbl...
> Is missing.. Any suggestions
>
|||Bobby,
What is the exact version of SQL Server 2005 (@.@.version) that you are using?
Danish is a supported FTS language in the June CTP Yukon version:
select * from sys.fulltext_languages
/* -- returns (23 row(s) affected)
lcid name
-- ---
2052 Simplified Chinese
1028 Traditional Chinese
1030 Danish
....
*/
Try the following
select * from myTable -- use contains vs. freetext
where contains(*,'formsof(inflectional,"danish_word")',l anguage 1030)
Also, when you created the fulltext index, did you define Danish as the
"Language for Word Breaker"? Is there a mix of languages in this column, if
so what did you use to define the "Language for Word Breaker"?
Thanks,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Bobby Henningsen" <bobhen@.tiscali.dk> wrote in message
news:uSXrxE80FHA.1040@.TK2MSFTNGP14.phx.gbl...
> More Info here .
> Using SQL 2005.. Trying something like this :
> Select * from myTable where freetext(*,'Drive',Language 1030) -- Lang.
> Danish
> Error saying that Locale ID is invalid. Every other language I've tried is
> working.. Anybody ?
> Regards
> Bobby Henningsen
>
> "Bobby Henningsen" <bobhen@.tiscali.dk> wrote in message
> news:eJrjYs70FHA.1028@.TK2MSFTNGP12.phx.gbl...
>
|||Im using the September CTP 9.0.1314. I've already checked the
master..syslanguages and "danish" is there. I've installed it on 2 different
machines and I get the same error. Installing the june CTP again and it
works fine. The locale ID 1029 isn't working either. I can't change the
"Language for Word Breaker" to danish, because it isn't in the list!! using
"Contains" gives me the exact same error. So for me it looks like the
ressouce isn't installed so the big question is : How do I do that ?
Regards .)
Bobby Henningsen
"John Kane" <jt-kane@.comcast.net> wrote in message
news:eSdxro$0FHA.3376@.TK2MSFTNGP14.phx.gbl...
> Bobby,
> What is the exact version of SQL Server 2005 (@.@.version) that you are
> using?
> Danish is a supported FTS language in the June CTP Yukon version:
> select * from sys.fulltext_languages
> /* -- returns (23 row(s) affected)
> lcid name
> -- ---
> 2052 Simplified Chinese
> 1028 Traditional Chinese
> 1030 Danish
> ...
> */
> Try the following
> select * from myTable -- use contains vs. freetext
> where contains(*,'formsof(inflectional,"danish_word")',l anguage 1030)
> Also, when you created the fulltext index, did you define Danish as the
> "Language for Word Breaker"? Is there a mix of languages in this column,
> if so what did you use to define the "Language for Word Breaker"?
> Thanks,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "Bobby Henningsen" <bobhen@.tiscali.dk> wrote in message
> news:uSXrxE80FHA.1040@.TK2MSFTNGP14.phx.gbl...
>

Locale and Culture

As I am developing reports to be used in severel different languages I would like to start a discussion about locales and cultures.

Hope to find answers to very simple questions like whats the difference between locale and culture and what determines the language used by the reporting service and the preview in visual studio.

Please share your expirence .

You may want to read this: http://msdn2.microsoft.com/en-us/library/ms156493.aspx

-- Robert