Sunday, March 25, 2012
Changing the Language Noise Words
I have searched high and low for an answer to this question. Please
tell me that it is a simple process...!
I have created a website in English using SQL 2000 as the database.
Now I have just launched the same website in French using exactly the
same schema (and same server) as the english website. Both use
full-text search. BUT...I notice that the noise word file being used
for both is English so, naturally, I need to change my French language
site to French. How can I do this?
I have already tried changing the database and field collation in the
French database and re-creating and re-populating the full-text index
but the English noise word file is still being used. Please, somebody
help!!
Darren,
You can switch to another language via dropping the existing FT Catalog and
re-creating it via the FT Indexing Wizard and when you pick the column (Text)
to be FT Indexed, click on the drop down box marked "Language for Word
Breaker" and select your language and then run a full population.
(Thanks to John for telling that trick!-)
Regards, Gerald.
"Darren Jensen" wrote:
> Hi,
> I have searched high and low for an answer to this question. Please
> tell me that it is a simple process...!
> I have created a website in English using SQL 2000 as the database.
> Now I have just launched the same website in French using exactly the
> same schema (and same server) as the english website. Both use
> full-text search. BUT...I notice that the noise word file being used
> for both is English so, naturally, I need to change my French language
> site to French. How can I do this?
> I have already tried changing the database and field collation in the
> French database and re-creating and re-populating the full-text index
> but the English noise word file is still being used. Please, somebody
> help!!
>
|||Darren,
Garald is correct. Just some additional info for future reference... You can
find out which noise.* is linked to what language via the Schema.txt file
under \FTDATA\SQLServer\Config, for example for noise.FRA is the noise word
file for French:
<stoplist
language="French_French"
file="noise.fra"
primarylanguage=12
sublanguage=1>
Regards,
John
"Gerald Baeck" <GeraldBaeck@.discussions.microsoft.com> wrote in message
news:209E46D0-5BEE-4531-8145-A9B8DEDFCF50@.microsoft.com...
> Darren,
> You can switch to another language via dropping the existing FT Catalog
and
> re-creating it via the FT Indexing Wizard and when you pick the column
(Text)[vbcol=seagreen]
> to be FT Indexed, click on the drop down box marked "Language for Word
> Breaker" and select your language and then run a full population.
> (Thanks to John for telling that trick!-)
> Regards, Gerald.
> "Darren Jensen" wrote:
|||Thanks, that worked a treat and very easy to do too!
Gerald Baeck <GeraldBaeck@.discussions.microsoft.com> wrote in message news:<209E46D0-5BEE-4531-8145-A9B8DEDFCF50@.microsoft.com>...
> Darren,
> You can switch to another language via dropping the existing FT Catalog and
> re-creating it via the FT Indexing Wizard and when you pick the column (Text)
> to be FT Indexed, click on the drop down box marked "Language for Word
> Breaker" and select your language and then run a full population.
> (Thanks to John for telling that trick!-)
> Regards, Gerald.
|||I have one follow up question on the subject of fulltext indexing with
French and that is how can I get the search to ignore accents? For
example if I search 'hopital' I would like the results to show all
places where it finds 'hpital' or 'hopital'. Is this possible?
Thanks.
jensendarren@.hotmail.com (Darren Jensen) wrote in message news:<c2c1a066.0411171919.75ce4862@.posting.google. com>...[vbcol=seagreen]
> Thanks, that worked a treat and very easy to do too!
> Gerald Baeck <GeraldBaeck@.discussions.microsoft.com> wrote in message news:<209E46D0-5BEE-4531-8145-A9B8DEDFCF50@.microsoft.com>...
|||Darren,
Unfortunately, the issue of accent sensitivity vs. accent insensitivity FTS
is more difficult to answer. This is a well known bug that has been around
for a long time (since SQL Server 7.0) and is truly only going to be fixed
in SQL Server 2005 <sigh>. As there are only workarounds for this bug in SQL
Server 2000 that require the use of duplicate data where you store the
non-accented search words, such as 'hopital'. You would then FT Index and FT
Search this column, while returning the accented search data (such as
'hpital') from another column back to the user. You will need to develop
accent removal procedures as well as use triggers (insert & update) to
maintain the currency of the two columns...
Regards,
John
"Darren Jensen" <jensendarren@.hotmail.com> wrote in message
news:c2c1a066.0411222026.3278d8fe@.posting.google.c om...
> I have one follow up question on the subject of fulltext indexing with
> French and that is how can I get the search to ignore accents? For
> example if I search 'hopital' I would like the results to show all
> places where it finds 'hpital' or 'hopital'. Is this possible?
> Thanks.
> jensendarren@.hotmail.com (Darren Jensen) wrote in message
news:<c2c1a066.0411171919.75ce4862@.posting.google. com>...[vbcol=seagreen]
news:<209E46D0-5BEE-4531-8145-A9B8DEDFCF50@.microsoft.com>...[vbcol=seagreen]
Catalog and[vbcol=seagreen]
(Text)[vbcol=seagreen]
|||Darren,
my workaround for this problem is to replace all special chars before
filling the index. I know it could take a while, but till Yukon is released
its the only way i think.
UPDATE [table] SET [field] = REPLACE([field], '', 'o')
Regards, Gerald.
"Darren Jensen" <jensendarren@.hotmail.com> schrieb im Newsbeitrag
news:c2c1a066.0411222026.3278d8fe@.posting.google.c om...[vbcol=seagreen]
>I have one follow up question on the subject of fulltext indexing with
> French and that is how can I get the search to ignore accents? For
> example if I search 'hopital' I would like the results to show all
> places where it finds 'hpital' or 'hopital'. Is this possible?
> Thanks.
> jensendarren@.hotmail.com (Darren Jensen) wrote in message
> news:<c2c1a066.0411171919.75ce4862@.posting.google. com>...
Changing the language in the Report Builder interface
Hi @. all,
I work on a german Windows environment and use the Report Builder. For showing details in their it is necessary to switch the German interface in Report Builder into English.
I already tried to change my environment into English but it even after a restart it did not change the Report Builder interface....
I also tried to search all the XML-files for a language setting - with no success....
Does anyone know how to do this? Would be very helpful....!
Thanks in advance,
Jochen
Schliff, in your report click an empty area then go to the properties window and there is a language settings-this allows you to set your language preference.
|||
First: thanks for the answer :-)
Second: it does not work ;-(
Maybe my explanation wasn't precise enough: I'm talking about the Report Builder on the Report Server, which is controlled and used via Internet Explorer....
Are we talking about the same or did I misunderstood something?
Jochen
|||So let me get this..
you have a report, which is published in german but you want to view the published report in english...
if so cant you just go to Tools and Options and select English as the language in IE?
|||Well - that works excellent!
Sometimes solutions are that easy - hard to believe that one does not try these first
Thank you very much, great work....
Jochen
sqlMonday, March 19, 2012
Changing SQL in runtime
Thank you
Hi,
I would rather use a stored procedure for that. THe logic in the stored procedure can decide which Query to execute.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
-
Thursday, March 8, 2012
Changing Reporting Website Language
We use English Server Operating Systems and Applications and German Client Software.
When we use our for German language configured Internet Explorers the Reporting Website is displayed in somewhat horrible translations.
How are we supposed to get the English website without changing the language settings at each IE we use?
You can remove the de driectory in the Report Manager\bin directory. This will disable the German translation. Just tried it myself and it works.
|||Thanks, it worked :).Wednesday, March 7, 2012
Changing parameter prompt depending on language
is it possible to change the prompt for a parameter depending on the browser
language ?
Kind regardsNo, not at this time. You can use a linked report to customize the labels
per language.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"obeckers" <obeckers@.discussions.microsoft.com> wrote in message
news:655D999C-AA4A-46DC-8424-C20942F24230@.microsoft.com...
> Hi,
> is it possible to change the prompt for a parameter depending on the
> browser
> language ?
> Kind regards
>
Friday, February 24, 2012
Changing Language Settings
I was wondering how to change the language settings on SQL Server. The server is currently set to US English, and I was wondering how it is possible to change it to UK English. The Server Regional Settings are set to UK English.
Also, on a semi-related topic, does SQL Server store dates in a universal format, and then when data is requested does it 'translate' these dates into the format required by that particular regional setting?
Thank you for any input
MarmanNot sure on the first question, but as far as dates are concerned, yes, they are stored in , I believe, integer format, and converted to whatever date format 1) you client uses, or 2) you ask for via CONVERT statement.
Changing language helps ( rrRenderingError) but.....
Of what is the language dependent? server properties ?
Can you explain how the export to PDF-format effects the report-language
properties and/or serverproperties ?
Thanks in AdvanceLanguage is a Report property.
Open the Properties window (F4), and select 'Report' from the dropdown list.
Language is the second-last property displayed.
If you set it to Dutch, functions like Month() will return Dutch month names.
My 2c.
Flip
"Bobby" wrote:
> I want to display my reports in dutch.
> Of what is the language dependent? server properties ?
> Can you explain how the export to PDF-format effects the report-language
> properties and/or serverproperties ?
> Thanks in Advance
>
>
>